Skip site navigation (1) Skip section navigation (2)

Re: ODBC & Transactions?

From: "Mike Miller" <mmiller(at)pooka(dot)otago(dot)ac(dot)nz>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC & Transactions?
Date: 2001-11-08 02:29:15
Message-ID: NFBBKNGDCLACAKIKLJIPAELNCBAA.mmiller@pooka.otago.ac.nz (view raw or flat)
Thread:
Lists: pgsql-odbc
> > CommitTransactionCommand doesn't necessarily mean COMMIT.
> > You have to use BeginTrans to turn of the autocommit mode
> > but it doesn't seem the cause of your case(It works well
> > here). Judging from the psqlodbc.log file you posted,
> > "rollback work" is issued by the differenct connection
> > from the one which issued "begin work" and "update ...".
> > Hmm are you using connection pooling ?

> You can see it using ODBC Datasource Administrator on your
> Windows control panel.
> Probably you can find the *connection pooling*(I'm not sure
> because I'm using Japanese version) tab together with
> *User DSN*, *System DSN*, ..., *Trace*, ...

Thanks, I found it.  Connection Pooling is off.  How does that relate to the
different connections
I am seeing in the log file?

Regards,
Mike Miller
Application Software Developer,
School Of Physical Education,
University Of Otago,
+64 3 479 9123
http://physed.otago.ac.nz


In response to

pgsql-odbc by date

Next:From: Yeffer Ochoa ParraDate: 2001-11-08 04:15:43
Subject: ODBC de 16 bit for windows
Previous:From: Hiroshi InoueDate: 2001-11-08 02:12:20
Subject: Re: ODBC & Transactions?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group