×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SQL Driver Issues - MDAC Didn't Resolve

SQL Driver Issues - MDAC Didn't Resolve

SQL Driver Issues - MDAC Didn't Resolve

(OP)
I'm having issues with a client computer running MS Office 2007 Pro on XP SP2. The client uses Access to connect to an MS SQL 2005 DB. Opening the DB gives an error about ODBC connection failed.

I went into the ODBC connections and, when attempt to open the applicable System DNS, I get: "The setup routines for the SQL Server ODBC driver could not be loaded due to system error code 193" followed by another error message:  "Could not load the setup or translator library". I get the same errors if I attempt to create a new DNS with the SQL Server driver.

The SQL Server driver listed in the Drivers tab say the version is Not Marked. I re-installed the MDAC from the C:\windows\inf directory but it made no difference. I also downloaded/installed SQL Server Express and SP to no avail. Lastly, I checked the existence of SQLSRV32.dll and refs in the registry which all checked out.

This is a new Dell PC, in-place with the user for about a week, and it was working fine when the user was initially migrated. I'm practically out of ideas. Any suggestions?

Thanks in advance,
Dan

RE: SQL Driver Issues - MDAC Didn't Resolve

Does the SQLSRV32.dll file actually exist in the proper directory? You usually get this error when the dll file is missing. Where did you check in the registry? The odbc area?

"I think we're all Bozos on this bus!" - Firesign Theatre jester

RE: SQL Driver Issues - MDAC Didn't Resolve

(OP)
Yes, I confirmed that SQLSRV32.dll is on the system disk and all registry entries refer to the correct path. I did this by searching the registry for every instance of "SQLSRV32.dll".

RE: SQL Driver Issues - MDAC Didn't Resolve

(OP)
The solution:  I resorted to a Windows Repair initiated from the OEM XP disk. All was well when the system came back up. I'm not crazy about carpet bombing a problem like that but it worked. Still no idea what the cause of the problem was.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close