BUG: ODBC TDS Error Calling Procedure with SQLTrace. (154891)



The information in this article applies to:

  • Microsoft SQL Server 6.5

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.

Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbnetwork KB154891