SQL 2000 ODBC driver install to support legacy application

Posted on 2011-03-15
Medium Priority
Last Modified: 2012-06-21
Hello experts,

I want to have SQL odbc driver to  Version 2000.86.3959.00  Date 17/2/2007
The current Version: 6.00.6002.18005, is causing issue.

Please advise as to how I should go about finding/downloading the driver?

Thanks and regards.
Question by:goprasad
  • 2
LVL 15

Expert Comment

ID: 35146946
It is system related. What system do you have? SQL Server ODBC Driver 2000.86.3959.00 is available from Windows Server 2003 SP2.

MDAC 2.8 SP1 is the same as with Windows Server 2000 SP4

Author Comment

ID: 35152039
It's running on windows 2008 STD OS
LVL 15

Accepted Solution

Daniel_PL earned 2000 total points
ID: 35154887
You can install client tools for SQL Server 2000 only, and use SQL Server native Client driver.

On your own risk you could take file sqlsrv32.dll located in %windir%\windows\system32\ from e.g. windows server 2003 sp2 and place it in your windows server 2008.
First backup your original file, next run cmd as an administrator use regsvr32 /u sqlsrv32.dll to unregister old library, copy new file and run regsrvr32 sqlsrv32.dll.
You should see new version after that.
Do not use dll file serving websites to get that file.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question