May 23, 2011 at 12:15 am
Does anyone know of a method to get SQL Server 2008 Management Studio to use the SQL Server 2008 R2 Native Client instead of the SQL Server Native Client?
ie use SQLNCLI10.dll instead of SQLNCLI.dll
The does not appear to be a provider= type connection string option available to use.
The same for SQL Server 2000 Enterprise Manager would be good as well. It still uses the old DBNETLIB.dll
The reason I want to force the use of the SQL Server 2008 R2 Native Client is to see if it fixes an issue where SQL Server clients running on Windows 7 have issues connecting to databases. Using the SQL Server 2008 R2 Native Client instead of SQL Server ODBC Driver Version 06.01.7600 was successful in fixing up a similiar problem with an ODBC Data source.
May 25, 2011 at 1:41 am
I think I have found my own answer to this one. The clients in question are going to use the net library they are intended to use. There is no provider/driver parameter such as in ODBC Data Sources.
SQLNCLI10.dll from SQL Server 2008 can be upgraded to the version that comes with R2 I guess.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply