Bug #25045 Transactions not Supported

• Submitted: 13 Dec 2006 18:17
• Modified: 4 May 2007 17:29
• Reporter: Jess Balint
• Status: Closed
• Category: Connector/ODBC
• Severity: S3 (Non-critical)
• Version: 5.00.10
• OS: Microsoft Windows (Windows)
• Assigned to: Bugs System

[13 Dec 2006 18:17] Jess Balint

Description:
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 21:27] Jess Balint

Committed in rev 745.