Groups | Blog | Home
all groups > sql server clients > december 2005 >

sql server clients : ODBC Error when Trying to use Query Analyzer


bocikt
12/16/2005 1:00:03 PM
I get the following error when trying to run Query Analyzer:

SQL Query Analyzer requires ODBC Driver version 3.7 or greater and ODBC
manager version 3.5 or greater. Incompatible version of odbc32.dll and/or
sqlsrv32.dll are installed on this machine

I am running the SQL Server 2000 Client with Service Pack 4.
I have Windows XP Professional with SP2
I recently updated Office with recent SPs and that is when everything seemed
to break.

I have unistalled the Client Software, Rebooted, Reinstalled, Rebooted and
Sue Hoegemeier
12/19/2005 5:26:58 PM
That kind of sounds like your MDAC installation is messed up
- try just reinstalling the most recent MDAC. You may also
want to check your MDAC installation using component
checker. You can download component checker and MDAC
versions from:
http://msdn.microsoft.com/data/mdac/downloads/default.aspx

-Sue

On Fri, 16 Dec 2005 13:00:03 -0800, bocikt
[quoted text, click to view]
bocikt
12/19/2005 5:55:02 PM
The component checker helped greatly. I had a .dll file that was the wrong
version. Once I put the correct version on, everything worked.

Thank you so much Sue

[quoted text, click to view]
Sue Hoegemeier
12/19/2005 9:34:53 PM
Glad it helped - thanks for posting back!

-Sue

On Mon, 19 Dec 2005 17:55:02 -0800, bocikt
[quoted text, click to view]
AddThis Social Bookmark Button