I too would appreciate the ability to use pgsqlODBC inside a COM+ transaction.
The problem lies in the lack of support for "SQL_ATTR_ENLIST_IN_DTC" which,
according to Microsoft, is the connect method used when ADO is used in a COM+
transaction. I don't think that the component HAS to be enlisted in a
Distributed Transaction for it to be in a COM+ transaction. I think it just
needs to respond "No, I will not allow myself to be distributed" when asked. I
looked at the code till my eyes crossed. I couldn't get it to compile, even
without my mods. Hiroshi said that he really didn't have time to impliment this
part of ODBC 3.0. My next thought was to have my company invest some money in
Hiroshi such that he would have some time to research and impliment this
option. They haven't said "yes" yet. For that matter, neither has Hiroshi! :)
Would your company like to help out? This is how Open Source Software stays
afloat! What a great software model.
CG
--- Raymond O'Donnell <rod@iol.ie> wrote:
> 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
> -------------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com