BUG: Invalid Syntax on SQLNumResultCols After Update Proc

• Microsoft SQL Server, version 4.21a

SYMPTOMS

The Microsoft Open Data Base Connectivity (ODBC) Open Data Services (ODS) Gateway driver which ships with SQL Server versions 4.21 and 4.21a gets an incorrect syntax error if SQLNumResultCols is called right after a SQLExecDirect of a procedure whose last step is an UPDATE, DELETE, or INSERT statement.

With a stored procedure of the following format:

   create procedure Insert_Num @key int, @value char(3) as
   insert into NumResults values (@key, @value)
   go

   SQLExecDirect(hstmt, "Insert_Num @key = 1, @value = 'aaa' ",SQL_NTS);

   SqlState = 37000, pfNative = 170
   szErrorMsg = "Line 1: Incorrect syntax near 'Insert_Num' "

CAUSE

The error only occurs if the procedure is executed in Transact-SQL syntax, not if the procedure is executed in ODBC syntax.

WORKAROUND

SQLNumResultCols works correctly if the procedure is executed in ODBC syntax:

   SQLExecDirect(hstmt, "{ call Insert_Num (1, 'aaa')}", SQL_NTS);

STATUS

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

The problem does not occur in the Microsoft ODBC ODS Driver version 2.50.0121 that ships with SQL Server version 6.0