Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  SQL 2000 driver connecting to SQL 2005

Author  Topic  bmwdks Starting Member 3 Posts Posted - 2009-09-04 : 09:50:24 We have users connecting to a SQL Server 2005 (9.0.1406) database using their old SQL Server 2000 client driver (SQLSRV32.DLL 2000.85.1117.00). I am wanting to move that database to another SQL Server 2005 (9.0.3042) but when I test the odbc connection using the SQL 2000 driver, it won't connect. It will connect using the SQL Native client driver (SQLNCLI.DLL 2005.90.2040.00). I was wondering why the old client driver no longer works? At what version did the 2000 client driver stop working? I don't really want to have to upgrade all the clients. Thanks, Bobby Sasseen Nashville, TN