Skip to Content.
Sympa Menu

freetds - RE: [freetds] ODBC 'trans2' patch

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page