Results 1 to 5 of 5

ODBC Data Source (ODBC or SQl Native Client)

  1. #1
    DLTaylor is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    3

    ODBC Data Source (ODBC or SQl Native Client)

    Hello Everyone,

    Im new to the forum and hope somebody can help.

    Im developing my first MS Access DB with a SQL 2017 BE.

    When i set-up the Data Source i have a few options that work. 2 in particular:



    ODBC Driver 13 for SQL Server
    SQL Server Native Client 11.0

    Which option would you suggest i opt for when setting up users?
    (are there any considerations / performance benefits etc..)

    Any advice very welcome!
    Kind regards

  2. #2
    Minty is online now Hacker
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    937
    Assuming you are in a corporate environment I would check what they have installed by default on the end users systems.
    I decided to develop with and use native client 11, only to find it needed installing on everyone's machine.

    By inclination I would generally always use the latest compatible driver as it will generally perform better, and support newer features better.
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    DLTaylor is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    3
    Quote Originally Posted by Minty View Post
    Assuming you are in a corporate environment I would check what they have installed by default on the end users systems.
    I decided to develop with and use native client 11, only to find it needed installing on everyone's machine.

    By inclination I would generally always use the latest compatible driver as it will generally perform better, and support newer features better.

    Thanks for reply - its small corporate (6 users) - all will eventually all be on windows 10 pro o/s. (but not now). There are no standard builds & i will have to add the drives.

    Knowing that ... is there a difference between the 2 below (they sound quite different but both achieve the same thing)

    ODBC Driver 13 for SQL Server

    SQL Server Native Client 11.0

    Kind regards
    Dan

  4. #4
    Minty is online now Hacker
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    937
    This page has some very in depth answers https://stackoverflow.com/questions/...r-odbc-drivers
    No point in me trying to elaborate on that lot !

    However the latest is the ODBC Driver 13 for SQL Server and seems to be where Microsoft is pointing you.
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    DLTaylor is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    3
    Quote Originally Posted by Minty View Post
    This page has some very in depth answers https://stackoverflow.com/questions/...r-odbc-drivers
    No point in me trying to elaborate on that lot !

    However the latest is the ODBC Driver 13 for SQL Server and seems to be where Microsoft is pointing you.
    Magic! - That's just what i was looking for. Thanks for your help

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 06-07-2015, 04:08 PM
  2. Changing ODBC Data Source
    By MattDyson1989 in forum Access
    Replies: 2
    Last Post: 07-23-2014, 05:58 AM
  3. Change source of ODBC data
    By Alan Cannon in forum Access
    Replies: 1
    Last Post: 07-15-2013, 01:46 PM
  4. Replies: 3
    Last Post: 01-06-2012, 03:17 PM
  5. Replies: 0
    Last Post: 08-30-2006, 01:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums