Article ID: 262519 - View products that this article applies to.
This article was previously published under Q262519
BUG #: 56244 (SQLBUG_70)
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:
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.
"[Microsoft][ODBC SQL Server Driver]Invalid Cursor Name"
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=enFor more information, contact your primary support provider.
Steps to Reproduce the Behavior in 32-bit ODBC Test (Odbcte32.exe)