T-SQL debugging - version of "NTWDBLIB.DLL"

[Gabriel Lozano-Morán]

Setup:
Windows XP Professional SP2
SQL Server 2000 Developer Edition SP4
Visual Studio .NET 2003 Enterprise Architect Edition
Project is ASP.NET Web Application
Enable SQL Debugging is set to true and user account has exec permissions to
extended stored procedure sp_sdidebug

I get the following exact error message when I run the project in debug mode
also when I manually try to attach the debugger to the the sqlservr.exe
process selecting T-SQL.
The driver "NTWDBLIB.DLL" doesn't support SQL debugging. Connections made
using this driver will not be debugged.

Can anyone point me in the right direction?

Gabriel Lozano-Morán

 

[Bob Milton]

NTWDBLIB is from the old native mode drivers (back to at least SQL
Server 4.2). To debug, I believe you have to use either ODBC or OLEDB
drivers.
Bob