Knowledge Base

BUG: ODBC TDS Error Calling Procedure with SQLTrace.

Article ID: 154891

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q154891

SYMPTOMS

If you call a procedure with the ODBC driver while providing a NULL parm, such as the following example:

   SQLExecDirect(hstmt, "{call TstPrc('Val1',NULL,'Val3')}", SQL_NTS);

and SQL Trace is active, the following error message appears:

SQLState: S1000, pfNative: 9
ErrorMsg: [Microsoft][ODBC SQL Server Driver]
Protocol error in TDS stream

WORKAROUND

Use the 4032 trace flag to trace the calls from the driver. For more information, please see the Trace Flags section in the Transact-SQL Reference guide.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft SQL Server ODBC Driver version 2.65.0201. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 2.65.0201 2.65.0212 trace

Keywords: kbbug kbnetwork KB154891