I haven't worked with ODBC in several years and I was never very fluent with it but I *think* you need to use a SQLSetConnectAttr call, passing the desired value to SQL_ATTR_AUTOCOMMIT.
This article describes the SQLSetConnectAttr call: <http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/o dbcsqlsetconnectattr.asp> Rhino ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Cc: <[EMAIL PROTECTED]> Sent: Friday, December 31, 2004 8:01 AM Subject: auto commit Hi All, I am using ODBC interface to access MySQL database. All DML oparations like insert, update and delete are performed using ODBC API's ( C program and ODBC API's). We start the transaction in the following order. 1.create savepoint a 2. do dml operation 3. commit if dml is success else rollback upto savepoint. In the above sequence we need to set autocommit= 0. This we executed in mysql prompt. How can we set autocommit = 0 feature in ODBC interface before doing any DML operation? Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
