Bug #25045 Transactions not Supported
Submitted: 13 Dec 2006 17:17 Modified: 4 May 2007 15:29
Reporter: Jess Balint Email Updates:
Status: Closed Impact on me:
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.00.10 OS:Windows (Windows)
Assigned to: Jess Balint CPU Architecture:Any

[13 Dec 2006 17:17] Jess Balint
Transactions are not supported in the ODBC driver. The transaction state (C6) is never entered in the connection.

How to repeat:
1. SQLSetConnectAttr to turn autocommit off
2. Insert a row or something that would change
3. SQLEndTran to commit

The transaction is not committed and SQLEndTran returns SQL_SUCCESS. The driver does not realize it's inside of a transaction.

Suggested fix:
Correctly detect when a transaction is started.
[13 Dec 2006 20:27] Jess Balint
Committed in rev 745.