I'm having a little bit of trouble with transactions.
I'm using psqlodbc-07.01.0008; PostgreSQL 7.1.2 on i686-pc-linux-gnu,
compiled by GCC 2.95.3; VB 6 SP5 with ADO (MDAC 2.6 SP1)
If I execute the SQL statements using ADO in VB6:
update mytable set myfield='changed-data' where myid = 1
and then I check the database using psql on the server box, myfield =
'changed-data'; and the rollback did *not* work.
In the postgres log appears:
NOTICE: ROLLBACK: no transaction in progress
I've attached a psqlodbc log file (if attachments are allowed - it should
Are transactions supported in postgresql ODBC?
(I've tried adoConnection.BeginTrans; etc as well with no success)
Any help appreciated.
Application Software Developer,
School Of Physical Education,
University Of Otago,
+64 3 479 9123
pgsql-odbc by date
|Next:||From: Dave Page||Date: 2001-11-07 08:11:37|
|Subject: Re: Weird problem with aggregate functions |
|Previous:||From: Alan R. Johns||Date: 2001-11-07 01:33:36|
|Subject: Re: Access 2000 & Views|