From: | "Austin Foxley" <afoxley(at)bluetooth(dot)com> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Distributed Transaction |
Date: | 2005-09-01 23:16:41 |
Message-ID: | 0776CBF22982E94794A5013351E594B30BCEEF20@ehost010-2.exch010.intermedia.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
In using this driver in connection with MSSQL, I've come across another
issue that needs clarification.
When attempting to run a query using OPENQUERY inside of an mssql
trigger, the ole db trace throws back at me the following error:
The operation could not be performed because the OLE DB provider
'MSDASQL' was unable to begin a distributed transaction.
[OLE/DB provider returned message: Unsupported connect attribute (Set)]
OLE DB error trace [OLE/DB Provider 'MSDASQL'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
I'm assuming this is because the psqlodbc driver doesn't support
distributed transactions. My question is whether there is a work around
for achieving the same effect?
Thanks
-Austin
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-09-02 07:50:12 | Re: Unicode support |
Previous Message | Cleber Nardelli | 2005-09-01 21:06:18 | Re: Transactions and SavePoints |