autocommit question

From: <Tom(dot)Zschockelt(at)flender(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: autocommit question
Date: 2004-07-23 07:32:51
Message-ID: OFA1CB81DA.D6EBAAF3-ONC1256EDA.0028A1CE-C1256EDA.00296AF7@flender.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
I've tried to set autocommit to off with the following command in a c++
application

SQLSetConnectAttr(hdbc, SQL_ATTR_AUTOCOMMIT,
(SQLPOINTER)SQL_AUTOCOMMIT_OFF, SQL_NTS);

but that doesn't have the expected result.

Autocommit is still in state "ON" -> every command is handled as a single
transaction ?

When using a explicit "BEGIN" -> real transaction handling is possible (as
expected)

Why does SQLSetConnectAttr not cause the expected behavior ?

Best regards

tom

Browse pgsql-odbc by date

  From Date Subject
Next Message Antonio Pennino 2004-07-23 13:42:08 problem with CVS version
Previous Message Matt Ittigson 2004-07-22 20:10:48 Re: psqlODBC / install / WinXP