Re: ODBC & Transactions?

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Mike Miller <mmiller(at)pooka(dot)otago(dot)ac(dot)nz>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC & Transactions?
Date: 2001-11-08 02:12:20
Message-ID: 3BE9EA04.237EE13@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Mike Miller wrote:
>
> > 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 ?
>
> I don't know if I am using connection pooling or not. Is it client side or
> server side?

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*, ...

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Mike Miller 2001-11-08 02:29:15 Re: ODBC & Transactions?
Previous Message Mike Miller 2001-11-08 01:50:00 Re: ODBC & Transactions?