freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: RE: [freetds] ODBC 'trans2' patch
- Date: Mon, 1 Sep 2003 12:03:00 +0200
>
> >
> > Applied!
> > Are you sure that ASE ODBC/MS ODBC driver do not use chained mode ?
>
> I ran a packet sniffer to catch the query the ASE driver was
> sending to turn off autocommit. It sent 'set transaction
> isolation level 1' then 'BEGIN TRANSACTION'.
>
> If you create a proc /w autocommit on, and execute it with
> autocommit off it will throw out an exception due to the
> different chained modes between the two. But if you try the
> same thing with the windows ASE driver it works.
>
> > What happen setting autocommit if we are in a transaction ?
>
> If you enable autocommit during an open transaction it's
> supposed to commit the open transactions according to the MS
> documentation.
>
> "If an application switches from manual-commit to autocommit
> mode, the driver commits any transactions currently open on
> the connection"
>
> take care,
> Peter
Applied!
Only a question: why "WHILE @@TRANCOUNT > 1 COMMIT COMMIT" and not
"WHILE @@TRANCOUNT > 0 COMMIT" ? Perhaps to suit all conditions (SET
CHAINED ON/OFF) ?
bye
freddy77
-
RE: [freetds] ODBC 'trans2' patch,
ZIGLIO Frediano, 09/01/2003
- RE: [freetds] ODBC 'trans2' patch, Peter Deacon, 09/01/2003
Archive powered by MHonArc 2.6.24.