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

View products that this article applies to.

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.

Back to the top

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/downloads/details.aspx?familyid=8B39115B-879D-45FE-80D1-4F0900993A92&displaylang=en (http://www.microsoft.com/downloads/details.aspx?familyid=8B39115B-879D-45FE-80D1-4F0900993A92&displaylang=en)

For more information, contact your primary support provider.

Back to the top

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.

Back to the top