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

Disable implicit transactions from ODBC driver on Windows?

From: "Doug Haddan" <dhadden2(at)home(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Disable implicit transactions from ODBC driver on Windows?
Date: 2001-02-26 18:13:19
Message-ID: 012c01c0a01f$cc97baa0$11841618@indpdnce1.mo.home.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Two questions really...

(1) Is there a way to turn off the implicit BEGIN that PsqlODBC sends to PostgreSQL? I want to use multiple SQL statements within transactions explicitly stated.

(2) Is there a way to stop PsqlODBC from sending ABORT when disconnnected and there is no transaction in progress? (Not so critical as first question.)

I know that the ODBC driver is sending the BEGIN and ABORT on its own by viewing the psqlodbc_%.log file and observing postmaster response.

I am using...
+ PostgreSQL v7.0.3 (on Linux)
+ PsqlODBC v6.50
+ Microsoft Windows NT SP6a
+ Microsoft Visual Basic 6 SP4
+ Microsoft ADO v3.520.5303.2

Following is a code sample with comments.

-------------------------------------------------------------------
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
With cn
    .ConnectionString = MyConnectionString
    .Open
    .BeginTrans  '<--- Seems to be ignored by ODBC driver.
    .CommitTrans  '<--- Seems to be ignored by ODBC driver.
End With
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
With rs
    .ActiveConnection = cn
    .Source = "BEGIN WORK;"
    .Open 
'-- At this point, the ODBC driver sends "BEGIN" and "BEGIN WORK;"
'-- to PostgreSQL and the postmaster complains by displaying the
'-- message "BEGIN: already a transaction in progress.
    .Source = "COMMIT WORK;"
    .Open  '<--- Seems to work OK.
End With
cn.Close
Set rs = Nothing
Set cn = Nothing
End
'-- The ODBC driver sends "ABORT" to PostgreSQL. The postmaster
'-- displays "ROLLBACK: no transaction in progress" and displays the
'-- message "pg_recvbuf: unexpected EOF on client connection".
-------------------------------------------------------------------

Any help would be appreciated.

Thanks!
Doug

pgsql-interfaces by date

Next:From: jrDate: 2001-02-27 00:06:13
Subject: perl return codes
Previous:From: J. T. VermeulenDate: 2001-02-26 14:21:06
Subject: Re: Suggested patches for libpq++/pgdatabase.*

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