Article ID: 200888 - Last Review: August 23, 2001 - Revision: 1.1

PRB: Cannot Invoke T-SQL Debugger to Automatically Appear Using ADO

This article was previously published under Q200888
Expand all | Collapse all

SYMPTOMS

When using Visual Basic 5.0 and stepping through ADO code that executes a SQL Server stored procedure, the T-SQL Debugger does not automatically start. However, using similar RDO code does start the T-SQL Debugger.

CAUSE

Visual Basic 5.0 does not have the appropriate hooks in place to automatically invoke the T-SQL Debugger when using ADO.

RESOLUTION

Upgrade to Visual Basic 6.0 and ADO 2.0 or later because these products have the appropriate hooks in place to automatically invoke the T-SQL Debugger.

STATUS

This behavior is by design.

APPLIES TO
  • Microsoft ActiveX Data Objects 2.0
  • Microsoft ActiveX Data Objects 2.01
  • Microsoft ActiveX Data Objects 2.1 Service Pack 2
  • Microsoft ActiveX Data Objects 2.5
  • Microsoft ActiveX Data Objects 2.6
  • Microsoft Visual Basic 5.0 Enterprise Edition
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
Keywords: 
kbdatabase kbmdacnosweep kbprb kbtsql KB200888
 

Article Translations