Re: ODBC & Transactions?

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@postgresql.org)