473,320 Members | 1,974 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 40301
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: M P | last post by:
What does this mean? I am accessing an ASP page that queries Access Database thru fileDSN. I'm using IIS 5.0 Win2K SP4 Microsoft OLE DB Provider for ODBC Drivers error '80004005' General...
2
by: john_20_28_2000 | last post by:
They are corrupt. I cannot get the odbc driver applet for sql server to open when I click add and I cannot configure any existing ones. And the usage of the drivers fail. Other ODBC drivers...
1
by: MLH | last post by:
I'm running XP. Is it required that a given ODBC driver be selected or set somehow as a default driver? Look at this... Here's the error: Error: ODBC call failed... Datasource not found and no...
1
by: chug | last post by:
I'm not a programmer but it's my job to solve this. Can someone help me with this error message? Microsoft OLE DB Provider for ODBC Drivers error '80040e14' Syntax error (missing operator)...
2
by: Charles shao | last post by:
Where to download ODBC.NET ? I searched by google. but all linkages are expired. Could you please give me an available link ? Thanks Charles Shao :-)
4
by: hugh welford | last post by:
Hi - using XP pro with IIS to develop offline asp data access site. Suddenly, my DSNs and odbc drivers have disappeared - the only thing I can think of is that an XP auto update has done this in...
2
by: pericpero | last post by:
Hi There seem to be a number of posts already with this error message but none of them have helped me ... I am trying to execute some dynamic SQL from an ASP form to update or delete from a...
0
by: Genken | last post by:
Please assist in this error i have provided the source code. Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) Too few parameters. Expected 1. <% Set objconn =...
1
by: ToddAndMargo | last post by:
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...
2
by: Rheal | last post by:
Hi Can someone help me. My error is : Microsoft OLE DB Provider for ODBC Drivers error '80040e07' Data type mismatch in criteria expression. /add.asp, line 73 my codes are <% dim...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.