By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

where do I download sql odbc drivers from?

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.