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: Peter Deacon <peterd AT iea-software.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] ODBC 'trans2' patch
  • Date: Thu, 28 Aug 2003 00:22:41 -0700 (Pacific Daylight Time)

On Wed, 28 Aug 2003, Frediano Ziglio wrote:

>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page