You are currently offline, waiting for your internet to reconnect

FIX: "Invalid Argument Value" Error with SQLSetConnectOption

This article was previously published under Q169218
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 4622 (ODBC30)
When SQL_ODBC_CURSORS is set to SQL_CUR_USE_ODBC using theSQLSetConnectOption and a connection to a data source is made, the nextcall to SQLSetConnectOption to set the SQL_CURRENT_QUALIFIER orSQL_ATTR_CURRENT_CATALOG fails with the following message:
szSqlState = "S1009", *pfNativeError = 0, *pcbErrorMsg = 55
szErrorMsg = "[Microsoft][ODBC Driver Manager] Invalid argument value"
To work around this problem, use SQLSetConnectOption to set theSQL_ODBC_CURSORS to SQL_CUR_USE_IF_NEEDED or SQL_CUR_USE_DRIVER. The ODBCCursor Library version 3.00.2822 resolves this issue.
Microsoft has confirmed this to be a problem in Microsoft Open DatabaseConnectivity version 3.0. This problem has been corrected in U.S. ServicePack 1 for Microsoft Open Database Connectivity, version 3.0. For moreinformation, contact your primary support provider.
This behavior is only seen with ODBC 2.X applications using a DriverManager 3.0 and a 2.X ODBC driver.
DM Cursorlibrary

Article ID: 169218 - Last Review: 01/11/2015 01:33:58 - Revision: 1.0

Microsoft Open Database Connectivity 3.0

  • kbnosurvey kbarchive kbbug kbfix kbprogramming KB169218