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

Re: ODBC & Transactions?

From: "Andrea Aime" <aaime(at)comune(dot)modena(dot)it>
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 08:56:27
Message-ID: 3BEA48BB.89D980DC@comune.modena.it (view raw or flat)
Thread:
Lists: pgsql-odbc
Mumble, can you show us the exact VB code you are using to
send these queries? Maybe it can help... (well, it would be
excellent if you could post a stripped down test case starting
from connection, query execution, etc. that shows the behaviour
you are experiencing)
Best regards
Andrea Aime

Mike Miller wrote:
> 
> 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
> 
>   ------------------------------------------------------------------------
>                               Name: psqlodbc_4294386287.log
>    psqlodbc_4294386287.log    Type: Documento di testo (application/x-unknown-content-type-txtfile)
>                           Encoding: quoted-printable
> 
>   ------------------------------------------------------------------------
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Responses

pgsql-odbc by date

Next:From: Bruce MomjianDate: 2001-11-08 20:05:54
Subject: [PATCHES] MD5 support for ODBC
Previous:From: Yeffer Ochoa ParraDate: 2001-11-08 04:15:43
Subject: ODBC de 16 bit for windows

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