[unixODBC-support] oracle and autocommit.

Nick Gorham 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
>properly.  
>
>Anyways, I guess it is a problem with the Oracle driver, but it's easy
>to work round.
>
>  
>
Ok,

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.

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org




More information about the unixODBC-support mailing list