PRB: Debugging Stored Procedure Fails with "Cannot load the DLL mssdi98.dll, or one of the DLLs it references" Error Message (291961)


The information in this article applies to:

  • Microsoft SQL Server 7.0
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.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Run the SQL Server 2000 Query Analyzer.
  2. Connect to the SQL Server 7.0 server.
  3. Specify pubs as the current database.
  4. Create the following stored procedure:
    Create procedure usp_DebugTest
@input int
as
    Print @input
go
  5. Press F8 to open the Object Browser.
  6. Browse to the pubs database, right-click usp_DebugTest, and then click Debug.
  7. Provide a value for the parameter.
  8. Click Execute. The error message listed in the "Symptoms" section occurs if the SQL Server 7.0 installation does not include the debugging interface.

REFERENCES

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

156096 INF: Tips for Debugging Stored Procedures from VC++

156099 INF: How to Debug an Extended Stored Procedure

170496 INF: Tips for Debugging Stored Procedures from Visual Basic 5.0

166280 DOC: T-SQL Debugger Server Setup Provides Incorrect Location

Modification Type:MajorLast Reviewed:3/30/2001
Keywords:kbDSupport kbprb KB291961
©2002 Microsoft Corporation. All rights reserved.