You are currently offline, waiting for your internet to reconnect

FIX: SQL Server ODBC Driver Generates Error When Executing a Stored Procedure on SQL Server 2000

This article was previously published under Q286359
An application that uses the Open Database Connectivity (ODBC) application programming interface (API) to call a SQL Server 2000 stored procedure that has a return value with the SQLExecDirect() API function and open a cursor on the resulting table may return the following errors:
szSqlState = "42000", *pfNativeError = 170, *pcbErrorMsg = 81MessageText = "[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '?'."
szSqlState = "42000", *pfNativeError = 16945, *pcbErrorMsg = 75MessageText = "[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared."
Before the SQL Server ODBC driver sends the command to the SQL Server, it restructures the ODBC call syntax to the SQL Server sp_opencursor command syntax. In the process of restructuring the command, the driver does not put a space after the name of the stored procedure. For example, calling this stored procedure causes the SQL Server ODBC driver to generate the following sp_cursoropen call.

Table Schema and Stored Procedure

create table testtable(f1 integer)gocreate proc testproc@p1 integerasselect * from testtable where f1 = @p1return 2				

ODBC Call Syntax

{? = call testproc(?)}				

Resulting Call to SQL Server 2000

exec sp_cursoropen @P1 output, N' EXEC @P1=testproc@P2? ', @P2 output, @P3 output, @P4 output, N'@P1 int OUTPUT,@P2 int', @P5 output, 1				
Note that the second parameter and the name of the stored procedure do not have a space between them; this causes the syntax error.
To resolve this problem, obtain the latest service pack for Microsoft Data Access Components 2.6. For additional information, click the following article number to view the article in theMicrosoft Knowledge Base:
300635 INFO: How to Obtain the Latest MDAC 2.6 Service Pack


The English version of this fix should have the following file attributes or later:
   Date      Time    Version        Size     File name     Platform   -------------------------------------------------------------   02/15/01  5:53P   2000.80.256.0  28,742   Odbcbcp.dll    x86   02/15/01  5:53P   2000.80.256.0  471,119  Sqlsrv32.dll   x86   02/15/01  5:44P   2000.80.256.0  90,112   Sqlsrv32.rll   x86				

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft Data Access Components 2.6 Service Pack 1.

Article ID: 286359 - Last Review: 09/26/2005 19:41:54 - Revision: 3.3

  • Microsoft Data Access Components 2.6
  • Microsoft SQL Server 2000 Standard Edition
  • kbhotfixserver kbqfe kbbug kbfix kbmdac260sp1fix kbqfe KB286359