Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL 2000 ODBC driver install to support legacy application

Posted on 2011-03-15
3
3,160 Views
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.
0
Comment
Question by:goprasad
  • 2
3 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
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.
http://support.microsoft.com/kb/884103

MDAC 2.8 SP1 is the same as with Windows Server 2000 SP4
http://support.microsoft.com/kb/899456
0
 

Author Comment

by:goprasad
ID: 35152039
It's running on windows 2008 STD OS
0
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 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.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

809 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