Transactional objects - Mailing list pgsql-odbc

From Raymond O'Donnell
Subject Transactional objects
Date
Msg-id 3E31D45D.2188.916BA1@localhost
Whole thread Raw
Responses Re: Transactional objects  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-odbc
Hello all,

I'm trying to create a COM+ transactional object that accesses
PostgreSQL via ADO via the ODBC driver - this object is to be called
by an ASP web application. However, when I mark the object as
"transactional" in Win2k's Component Services and then run the app,
it crashes with the following error:

CGVECLogin.LoginChecker (0x8004D00A)
Unknown connect option (Set)
/login/checkloggedin.asp, line 7

Marking the object as "Does not support transactions" cures the
problem, but I lose the transaction support which I would really like

to have.

I don't have any way of intercepting the detailed calls from ADO to
the Postgres box (the logs generated by the ODBC driver don't seem to

show this stuff), so I don't know what exactly is passing between the

two.

Any help or pointers appreciated..........I'm using version
7.02.00.05 of the ODBC driver.

--Ray.

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------


pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Trying to debug psqlODBC
Next
From: Stefanos Karasavvidis
Date:
Subject: unicode driver + text fields as primary keys