Query Analyzer Failure

  • I am unable to run the debugger from query analyzer and get the error:

    ODBC: Msg 0, Level 16, State 1

    [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the DLL mssdi98.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

    I have both SQL Server 7 and SQL Server 2000 (MSDE) installed and both directories contain the DLL msidi98.dll. I am using the Query Analyzer for SQL Server 2000.

    Any assistance in resolving this issue would be greatly appreciated as I am building rather complex T-SQL procedures that need to be debugged.

  • Check your sysetm variable 'PATH' to make sure SQL Server 2000 executiable path is in front of SQL Server 7.0 programs path.

  • I checked the path and it may have been able to cause the problem, so I updated it and still got the same error. Then I logged onto a server with a clean SQL Server 2000 installation, connected to the server on the network using enterprise manager, and got exactly the same error when I tried to run the T-SQL debugger. The MS Knowledgebase doesn't seem to have any useful documentation covering this problem. Why not? If I have this problem on my only two computers, then wouldn't others have the same problem?

  • there are 2 possible solutions for this problem.

    1. Install SP# for SQL Server 2000.

    or

    2. Configure ur server using "server N/W Utility" by disableing all other protocols other than TCP/IP

    hope this will solve ur problem

  • The problem is most likely, you are using the SQL 2000 Client tools the hit SQL 7 database. This will not work.

    Curtis Smith

    Application Dev. Mgr

    DBA




    Curtis Smith
    SQL Server DBA
    Well in worked in Theory ...

  • I've partially resolved this problem, or at least learned a little more about it. Yesterday the debugger worked when debugging a procedure on the server on my local computer. It still does not work when trying to debug procedures on a remote server. The remote systems are all SQL Server 2000 as is my Query Analyzer. I'm still working on it and will review the links Allen_Cui provided and check out service packs as recommended by pratapkrg. My copy of the Query Analyzer resides on a Windows 2000 platform which can only have MSDE or Personal SQL Server installed. I don't have permissions to disable protocols on the servers I connect.

    SQL Server Connections:

    1) Local (2 databases (MSDE/2000)

    2) Midwest (1 large database (SQL Svr 2k on network)

    3) Development Team (same office but SQL Svr 2k on network)

    Steve King

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply