Perhaps, but the MS Access ODBC Driver would run in an MTS transaction, even
though there is no transaction support in access.
I use ODBC like I drive my car. I put in the key, turn it, and it just works.
What could I do to get under the hood and find out what this mysterious "Set"
thing might require to function properly?
I don't care to even have the PostgreSQL transaction auto-roll-back when the
MTS Transaction fails. I need the transaction support for the larger operation
of which the database transactions are a small part.
CG
--- Hiroshi Inoue <Inoue@tpf.co.jp> wrote:
>
> Maybe MTS requires Distributed transaction support but
> PostgreSQL(and of cource psqlodbc driver) doesn't support it.
> I'm not sure if MTS provides the option to work with non-
> distributed system.
>
> regards,
> Hiroshi Inoue
> http://w2422.nsk.ne.jp/~inoue/
__________________________________________________
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com