ODBC Question

Posted in 2003

Topics: Connectivity: ODBC / JDBC / .NET

Manas Dadarkar — Sun, 31 Aug 2003 17:43:25 -0700 (PDT) — source: Usenet: comp.databases.informix

Hi, Can anyone tell me whether it is possible to know whether any transaction is running for an ODBC connection via ODBC/CLI calls? Thanks in advance, Regards, -Manas __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com sending to informix-list

↪ replying to Manas Dadarkar

Jonathan Leffler — Mon, 01 Sep 2003 04:56:21 GMT — source: Usenet: comp.databases.informix

Manas Dadarkar wrote: > Can anyone tell me whether it is possible to know > whether any transaction is running for an ODBC > connection via ODBC/CLI calls? ODBC has AutoCommit. If it is on, you are not in a transaction. If it is off, you probably are in a transaction. You can always try executing a BEGIN WORK statement: if it succeeds, you were not in a transaction; if it fails, either the database does not support transactions (one error code) or you were already in a transaction. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/