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