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

ODBC & Transactions?

From: "Mike Miller" <mmiller(at)pooka(dot)otago(dot)ac(dot)nz>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC & Transactions?
Date: 2001-11-07 03:45:08
Message-ID: NFBBKNGDCLACAKIKLJIPGELFCBAA.mmiller@pooka.otago.ac.nz (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

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:

begin work
update mytable set myfield='changed-data' where myid = 1
rollback work

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

Are transactions supported in postgresql ODBC?

(I've tried adoConnection.BeginTrans; etc as well with no success)

Any help appreciated.

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

Attachment: psqlodbc_4294386287.log
Description: application/octet-stream (39.3 KB)

Responses

pgsql-odbc by date

Next:From: Dave PageDate: 2001-11-07 08:11:37
Subject: Re: Weird problem with aggregate functions
Previous:From: Alan R. JohnsDate: 2001-11-07 01:33:36
Subject: Re: Access 2000 & Views

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