Solved

SQL 2000 ODBC driver install to support legacy application

Posted on 2011-03-15
3
2,950 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Citrix XenDesktop 7.6 Citrix Policies Audio
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
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 information from SQL Server on Database, Connection and Server properties

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now