where do I download sql odbc drivers from?

[ToddAndMargo]

Hi All,

Okay. I give up. I need to install the latest ODBC
drivers that work with Microsoft's SQL server 2000.
(I am write a Lotus Approach front end to an existing
sql2000 database.)

I have looked all over Microsoft's download web site,
but no joy (I may not have know what to search for or
what the answer that came back meant.)

Where do I download these drivers from?

Many thanks,
-T

[Erland Sommarskog]

Re: where do I download sql odbc drivers from?

ToddAndMargo (ToddAndMargo@N oSpam.verizon.n et) writes:

Okay. I give up. I need to install the latest ODBC
drivers that work with Microsoft's SQL server 2000.
(I am write a Lotus Approach front end to an existing
sql2000 database.)
>
I have looked all over Microsoft's download web site,
but no joy (I may not have know what to search for or
what the answer that came back meant.)
>
Where do I download these drivers from?

Which operating system do you have? If you have Windows XP or later, you
have the ODBC driver you need on the machine.

Else go to http://www.microsoft.com/downloads/S...displaylang=en
and search for MDAC. Which version you should pick depends on your OS. The
latest version is 2.8, but it does not run on Windows NT and older systems.
You need at least 2.6 to connect to SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx