I'm trying to debug a stored procedure butkeep getting this 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.).

mssdi98.dll is installed in C:\Program Files\Microsoft SQL
Server\80\Tools\Binn, and Dependency Walker does not indicate that any
required DLLs are missing.

Any suggstions?

Thanks,

Jon

You can get that error when the dlls are not registered. You
can find the steps for configuring the debugger and what
needs to be registered in the books online help topic:
Troubleshooting the Transact-SQL Debugger
You can do a search in books online for mssdi98 and it will
pull up the topic.

-Sue

On Mon, 3 Nov 2003 08:59:29 -0500, "Jon Prisbe"
<jprisbe@steelcase.com> wrote:

>I'm trying to debug a stored procedure butkeep getting this 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.).
>
>mssdi98.dll is installed in C:\Program Files\Microsoft SQL
>Server\80\Tools\Binn, and Dependency Walker does not indicate that any
>required DLLs are missing.
>
>Any suggstions?
>
>Thanks,
>
>Jon
>

Hi Jon,

Thank you for using MSDN Newsgroup! It's my pleasure to assist you with your issue.

From your description, I understand that you would like to debug a stored procedure and want
to suppress the "Cannot load the DLL mssdi98.dll" error. Have I fully understood you? If there
is anything I misunderstood, please feel free to let me know.

Based on my research, I find that when you debug a Microsoft SQL Server 7.0 stored
procedure from the Microsoft SQL Server 2000 Query Analyzer (QA), you may receive this
error messagem. However, I'm not sure of what environments are you in when you performed
your debugging. Could you specify more so that we can make things clearer? Thanks in
advance!

As I know, 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 on the other hand, the typical installation of SQL
Server 2000 does include the development tools and debugging interface.

To workaround this issue, you can try to 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.

For more information on debugging a stored procedure, please refer to the following article
describing in different environments:

170496 INF: Tips for Debugging Stored Procedures from Visual Basic
http://support.microsoft.com/?id=170496

156096 INF: Tips for Debugging Stored Procedures from VC++
http://support.microsoft.com/?id=156096

Jon, does this answer your question? Please feel free to let me know if this help solves your
problem. If there is anything more I can still assist you with, please feel free to post it in the
group.


Best regards,


Billy Yao
Microsoft Online Partner Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.