The information in this article applies to:
BUG #: 4841 (Brazos) SYMPTOMSIf an application does the following in the Microsoft Access 7.0 or 97 version of the ODBC drivers more than seven times SQLSetConnectOption(hdbc, SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF);The error generated is: If the application calls SQLExecDirect with any SQL statement, the error generated is:
WORKAROUNDTo work around this problem, do not set the SQL_AUTOCOMMIT option repeatedly within a connection. The SQL_AUTOCOMMIT option is a per-connection option. Once this option is set, it stays valid until the connection is dropped; an ODBC application does not have to set the option repeatedly within a connection. STATUSMicrosoft has confirmed this to be a problem in the Microsoft Access ODBC driver version 3.50.3602. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. Additional query words: SQLEndTran SQLSetConnectAttr
Keywords : kbprg SSrvProg |
Last Reviewed: August 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |