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