SQL Server 2000 ODBC configuration error

[Wiley Q. Hacker]

Hi all:

I'm having trouble with the SQL Server 200 ODBC client. Apparently, some
weird install on my system has destroyed the registry setting for the
client. Even a complete MDAC 2.7 reinstall isn't fixing it.

When I try to configure a DSN that uses the SQL Server driver, I get the
following two error messages in succession.

1. Message = The setup routines for the SQL Server ODBC driver could not be
loaded due to system error code 126.
2. Dialog Title = Driver's ConfigDSN, ConfigDriver, or ConfigTranslator
failed. Message = Could not load the setup or translator library.

In the ODBC Administrator, under the Drivers tab, the SQL Server driver is
listed, but none of it's properties, such as Version and Company are shown.

How do I fix this? I've tried a full SQL Server install and a full MDAC 2.7
install, and they don't work.

Any help would be greatly appreciated.

[Hina Masud [MS]]

Hi Wiley,

Try removing the MDAC completely and installing MDAC 2.5 to begin with and if everything works with that then
upgrade it to MDAC 2.7.

Thank you
Hina Masud
Microsoft

Disclaimer:
This posting is provided AS IS with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

--------------------
-From: "Wiley Q. Hacker" <wiley_...@hotmail.com>
-Subject: SQL Server 2000 ODBC configuration error
-Date: Thu, 23 May 2002 11:00:05 -0700
-Lines: 24
-X-Priority: 3
-X-MSMail-Priority: Normal
-X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
-X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
-Message-ID: <OAdTsOoACHA.1836@tkmsftngp05>
-Newsgroups: microsoft.public.sqlserver.connect
-NNTP-Posting-Host: unk-17-29-77.peoplesoft.com 209.17.29.77
-Path: cpmsftngxa07!cpmsftngxa10!tkmsftngp01!tkmsftngp05
-Xref: cpmsftngxa07 microsoft.public.sqlserver.connect:29369
-X-Tomcat-NG: microsoft.public.sqlserver.connect
-
-Hi all:
-
-I'm having trouble with the SQL Server 200 ODBC client. Apparently, some
-weird install on my system has destroyed the registry setting for the
-client. Even a complete MDAC 2.7 reinstall isn't fixing it.
-
-When I try to configure a DSN that uses the SQL Server driver, I get the
-following two error messages in succession.
-
-1. Message = The setup routines for the SQL Server ODBC driver could not be
-loaded due to system error code 126.
-2. Dialog Title = Driver's ConfigDSN, ConfigDriver, or ConfigTranslator
-failed. Message = Could not load the setup or translator library.
-
-In the ODBC Administrator, under the Drivers tab, the SQL Server driver is
-listed, but none of it's properties, such as Version and Company are shown.
-
-How do I fix this? I've tried a full SQL Server install and a full MDAC 2.7
-install, and they don't work.
-
-Any help would be greatly appreciated.
-
-
-
-