FIX: SQLSetCursorName Fails When "Use ANSI Quoted Identifiers" Is Cleared (262519)

The information in this article applies to:

Microsoft SQL Server 7.0
Microsoft Open Database Connectivity 2.1
Microsoft ODBC Driver for SQL Server 3.7

This article was previously published under Q262519

BUG #: 56244 (SQLBUG_70)

SYMPTOMS

When you try to use a data source name (DSN) entry that does not have the Use ANSI Quoted Identifiers option selected to try to set a cursor name (through the use of the SQLSetCursorName API), the following error message appears:

"[Microsoft][ODBC SQL Server Driver]Invalid Cursor Name"

To work around this problem, select the Use ANSI Quoted Identifiers option in the DSN. For additional information on ODBC, please refer to the platform SDK and MSDN documentation.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 7.0. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:

http://www.microsoft.com/sql/downloads/sp3.asp

For more information, contact your primary support provider.

MORE INFORMATION

Steps to Reproduce the Behavior in 32-bit ODBC Test (Odbcte32.exe)

Create a DSN to connect to Microsoft SQL Server.
Clear the Use Ansi Quoted Identifiers option in the DSN.
Within ODBC Test, select Full Connect and choose the DSN that you modified in step 2.
From the Stmt menu, choose SQLSetCursorName. In the SQLSetCursorName dialog box, specify any cursor name (such as "Cl").
Click ok. The error message will appear.

Modification Type:	Minor	Last Reviewed:	9/26/2005
Keywords:	kbHotfixServer kbQFE kbBug kbfix KB262519