Transactional objects

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(at)iol(dot)ie Galway Cathedral Recitals
-------------------------------------------------------------