Topics

ODBCConnection object changes

• The AutoCommit and CommitOnDisconnect properties are moved from the ODBCResultSet object to ODBCConnection in order to support Transaction Mode, CommitTransactions, and RollbackTransactions. These take no arguments. AutoCommit defaults to True and can be set False to enter Transaction Mode, if the driver and data source support transactions.
• The methods GetRegistrationInfo and IsTimedOut have been removed.
• The DisconnectTimeOut and Exclusive properties have been removed.
• Support for asynchronous execution of queries has been removed. The IsSupported property returns False so that scripts that attempt to use asynchronous mode when available will behave correctly.
• The ConnectTo method does not perform the auto-registration of unregistered data sources.
• The ExecProcedure method has been removed. A new ExecProcedure method is added in ODBCResultSet object to execute a stored procedure.

• The ListProcedures method does not work with some drivers.
• In some cases, an ODBC driver indicated that it did not support a certain mode although it actually did. The IsSupported property of the ODBCConnection object may report incorrectly due to bugs in the ODBC driver. On the DB_SUPP_READONLY item, it may report incorrectly due to limitations in ODBC.

• The properties AutoCommit and CommitOnDisconnect have been moved to the ODBCConnection object. The AutoCommit property of the ODBCConnection object can be set False (when supported by the DBMS) to enter Transaction Mode, which applies to all queries and result sets associated with that connection.
• The Transactions method and the Commit and Rollback functions of the Close method have been replaced by the CommitTransactions and RollbackTransactions methods of the ODBCConnection object. These new methods take no arguments and apply to all transactions pending through that connection. You might get error 720, "You cannot have more than one statement active, when SQL_AUTOCOMMIT is false" for INTERSOLV drivers. As a workaround, Lotus suggests to "Call Res.LastRow" after "Res.Execute" and before any "Res.UpdateRow" or "Res.Delete Row."
• The Asynchronous and Override properties have been removed.
• The new ExecProcedure method allows you yo execute a stored procedure.
• The RefreshRow method has been removed.