Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3856
  • Last Modified:

SQL 2000 ODBC driver install to support legacy application

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
goprasad
Asked:
goprasad
  • 2
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
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
 
goprasadAuthor Commented:
It's running on windows 2008 STD OS
0
 
Daniel_PLDB Expert/ArchitectCommented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now