[unixODBC-support] oracle and autocommit.
tmorgan at ncipher.com
Mon Nov 26 14:02:56 GMT 2007
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.
On Fri, 2007-11-09 at 09:33 +0000, Nick Gorham wrote:
> Trevor Morgan wrote:
> >Hi! I've been banging my head against this problem for several days.
> >The oracle unix odbc driver seems to be ignoring the SQL_ATTR_AUTOCOMMIT
> >connection attribute. I've set it to SQL_AUTOCOMMIT_OFF, but every
> >statement still gets committed automatically. With the same piece of
> >code, I'm seeing correct behaviour for Oracle, DB2 and SQL Server on
> >Windows, and correct behaviour for DB2 on Linux, so it's definitely an
> >oracle/unixodbc issue.
> >Is there some configuration setting I'm missing?
> I think thats going to be a driver issue.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the unixODBC-support