Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Choosing the correct driver


Choosing the correct driver

Author
Message
victoryismine06
victoryismine06
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 45
I'm writing some documentation on how to connect Access to SQL via ODBC. I honestly always just choose "11.0" when it comes to drivers, just because. But I'm wondering what determines the driver I "should" be using?

Does the version of SQL Server determine this? And I'm assuming the "User's" computer won't have all the driver's I'm seeing here so can someone just clarify the rules to choosing the correct driver?





*I also asked this on StackOverflow, so if you're a user of that as well and come up with an answer, feel free to do it there as well so I can give you some points Smile
mysorian
mysorian
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 101
As far as connecting to SQL Server 2012 any of the ODBC versions will work (6.0, 10.0, 11.0). The lower versions may not be able to handle more recent functionality/features of SQL Servers.

6.0, 10.0,11.0 refer to the following dll files:

6 : file name sqlsrv32.dll
10: file name sqlncli10.dll
11: file name sqlncli11.dll

There is an old article (sqlserver2005) that you may want to read:
http://www.aspfree.com/c/a/database/using-ado-with-the-sql-native-client/#more-532

This next one is about version 11.0
http://opensource.sys-con.com/node/2249144
victoryismine06
victoryismine06
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 45
Hmm, I figured it was something like that. There's one article that has some info if someone else comes across this that has some helpful info:

http://blog.flex2sql.com/index.php/2009/02/how-and-when-to-use-sql-server-native-client/
SQL Surfer '66
SQL Surfer '66
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 328
It's not just a question of which driver to use, but also if you need to use the 32 bit and/or 64 bit driver(s).

There's two ODBC Administrators:

32 bit %windir%\syswow64\odbcad32.exe
64 bit %windir%\system32\odbcad32.exe

General rule:
32 bit software uses 32 bit (ODBC-)drivers
64 bit software uses 64 bit (ODBC-)drivers
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search