[unixODBC-support] oracle and autocommit.
nick.gorham at easysoft.com
Mon Nov 26 15:00:33 GMT 2007
Trevor Morgan wrote:
>Further to this problem, it seems that everything works fine as long as
>I set SQL_ATTR_AUTOCOMMIT _after_ I call SQLConnect(). According to the
>MSDN (http://msdn2.microsoft.com/en-us/library//ms713605.aspx), you
>should be able to set this attribute either before or after connection,
>but Oracle on Linux is the only setup I can find that doesn't do this
>Anyways, I guess it is a problem with the Oracle driver, but it's easy
>to work round.
The driver manager passes on the SQL_ATTR_AUTOCOMMIT state after loading
the driver, but before connecting, maybe that driver is ignoring it if
its before the connect.
More information about the unixODBC-support