Installed SQL Server 2005 Driver but it does not appear in Driver List 1

[JohnBates]

hi everyone,

On this SQL 2000 machine, I installed the SQL Server 2005 driver
(sqljdbc_1.1.1501.101_enu.exe)

Seemed to install fine.

However, when I go into ODBC Data Sources, the 2005 driver does not appear in the "Drivers" column. The SQL Server 2000 driver is still there, but no 2005 driver.

I need the 2005 driver so I can configure a DSN pointing to the 2005 server so the app can use the databases on the server rather than the PC.
This is on an XP desktop.

Can anyone explain this?

 

[gmmastros]

Looks like you installed the jdbc driver instead of the named clients provider.

Take a look at this page. You'll probably want to download sqlncli.msi

http://www.microsoft.com/downloads/...60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[JohnBates]

Thanks George. You're correct - I installed the wrong driver.

John