Microsoft KB Archive/291961

= PRB: Debugging Stored Procedure Fails with &quot;Cannot load the DLL mssdi98.dll, or one of the DLLs it references&quot; Error Message =

Article ID: 291961

Article Last Modified on 3/30/2001

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q291961



SYMPTOMS
When you debug a Microsoft SQL Server 7.0 stored procedure from the Microsoft SQL Server 2000 Query Analyzer, you may receive the following error message:

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.



CAUSE
The Typical installation of SQL Server 7.0 does not include development tools or a debugging interface, which is required to debug a SQL Server 7.0 stored procedure from the SQL Server 2000 Query Analyzer. By default, the Typical installation of SQL Server 2000 does include the development tools and debugging interface.



RESOLUTION
Make sure that the SQL Server 7.0 installation includes the debugging interface by using these steps:
 * 1) Rerun the SQL Server 7.0 setup.
 * 2) In the Setup dialog box, select Custom Installation.
 * 3) In the Custom Installation dialog box, select Development Tools, and then select Debugging Interface.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
 Run the SQL Server 2000 Query Analyzer. Connect to the SQL Server 7.0 server. Specify pubs as the current database.  Create the following stored procedure: Create procedure usp_DebugTest @input int as Print @input go  Press F8 to open the Object Browser.</li> Browse to the pubs database, right-click usp_DebugTest, and then click Debug.</li> Provide a value for the parameter.</li> Click Execute. The error message listed in the &quot;Symptoms&quot; section occurs if the SQL Server 7.0 installation does not include the debugging interface.</li></ol>

<div class="references_section">