Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL 2000 ODBC driver install to support legacy application

Posted on 2011-03-15
3
Medium Priority
?
3,695 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
[X]
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
  • 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 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.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

705 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