Setup Routines for the sql server odbc driver could not be accessed

QRunning onWindows XP SP3 ... When I try to create a System DSN for SQL Server (SQL2005), message saying "the setp routines the sql server odbc driver could not be accessed"  No eror nmber is displayed - just "Please Reinstall the driver"

Of course, this being a WIn XP SP3 setup, MDAC installer won't run.
I downloaded the component checker and ran it - no trouble found.
I ran regsvr32 on all dlls in the "\program files\common files\system\ole db" directoryh.  I rebooted the computer.  I still got the same result ... setup routines could not be accessed.

Additional details: SQL Express 2005 is installed on this computer and works very well with application it is used with; also another application uses ADO to access a SQL Server 2005 on our LAN.

So how do I fix this ODBC Issue with the SQL Server driver?
LVL 1
grant-ellsworthAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brendt HessSenior DBACommented:
Check the article below.  This should work exactly the same on XP SP3.

http://www.macropool.com/en/download/mdac_xp_sp2.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim P.Commented:
I may have a solution, assuming this is an I386 system.

Under Regedit look at the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI. Make sure the MyODBCCall has a corresponding HKLM\SOFTWARE\ODBC\MyODBCCall in the registry.
0
grant-ellsworthAuthor Commented:
Thanks to behesst and jimpen for the suggestions.  The problem laptop is out of office for a few days.  I'll try these solutions when it returns.  I also found another suggestion elsewhere about how to force the MDAC Drivers to be re-installed.  The suggestion was to get the latst MDAC_TYOE.exe to update mdac 2,81.  Then, before run ning it, goto the Properties pages compatibility page and sset compatibility to Windows NT or Windows 2000.  

Any comments?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

grant-ellsworthAuthor Commented:
OOoops!! That should have read "MDAC_TYPE.EXE" !!!!
0
Jim P.Commented:
If the workstation is XP SP3, you can't de/re install the MDAC. After XP SP1 (or SP2); the MDAC has become wedded to the OS.

We are working the issue.
0
grant-ellsworthAuthor Commented:
For JimPen, I ran a test on a different machine with Windows XP SP3!) since the problem machine won't be available for several days.  I set the Properties compatibility to Windows 2000 and ran the MDAC installer with that compatibility.  It ran without complaining about operating system and the ODBC functions seek to be working as expected.  Now the problem may be to force theupdate to MDAC if any are required.  Note: I'm not going to close this issue until I can access the original problem machine where the sql server odbc driver is not available.  Any comments on this "test?"
0
Jim P.Commented:
0
grant-ellsworthAuthor Commented:
This solution using the mdac.inf + the ms installer was necessary on one of the 2 machines where we had the issue.  Even resetting the compatibility level in MDAC_TYP.EXE did not work.  On the other machine, resetting the compatibility level in the MDAC_TYP.EXE and rerunning the installer worked.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.