469,125 Members | 1,709 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

where do I download sql odbc drivers from?

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
Jun 27 '08 #1
4 39768
ToddAndMargo (To**********@NoSpam.verizon.net) 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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 27 '08 #2
Erland Sommarskog wrote:
ToddAndMargo (To**********@NoSpam.verizon.net) 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.
w2k-pro-sp4 on both of the computers in question.

Thank you!

-T
Jun 27 '08 #3
ToddAndMargo (To**********@NoSpam.verizon.net) writes:
w2k-pro-sp4 on both of the computers in question.
OK, if you don't have SQL Server on any of the machines, you need to get
MDAC 2.6 at least, as Win2000 shipped with MDAC 2.5.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 27 '08 #4
Erland Sommarskog wrote:
ToddAndMargo (To**********@NoSpam.verizon.net) writes:
>w2k-pro-sp4 on both of the computers in question.

OK, if you don't have SQL Server on any of the machines, you need to get
MDAC 2.6 at least, as Win2000 shipped with MDAC 2.5.

This is what confused me :
http://www.microsoft.com/downloads/r...DisplayLang=en

This release does not include Microsoft Jet, the Microsoft Jet OLE DB
Provider, the Desktop Database Drivers ODBC Driver, or the Visual FoxPro
ODBC Driver.

It sounded to me like it did not include ODBC drivers at all.

I will download it and see.

Many thanks,
-T
Jun 27 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Charles shao | last post: by
4 posts views Thread by hugh welford | last post: by
1 post views Thread by ToddAndMargo | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.