Cannot wrap stored procs in transaction via sql server link

From: "LLC" <kevin(at)kevinkempterllc(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Cannot wrap stored procs in transaction via sql server link
Date: 2006-06-21 00:04:39
Message-ID: 1150848279.v2.fusewebmail-164106@ffuse12
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi List;

We've setup a sql server link to a postgres db via the postgres ODBC
driver. queries work fine except we see this when trying to embed a stored
proc within a transaction:

[OLE/DB provider returned message: Unsupported connect attribute (Set)]

OLE DB error trace [OLE/DB Provider 'MSDASQL'
ITransactionJoin::JoinTransaction returned 0x8004d00a].

Anyone have any ideas how to debug/resolve this ?

As always, Thanks in advance for your help & support...

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message noreply 2006-06-21 07:09:43 [ psqlodbc-Bugs-1000671 ] psqlodbc does not compile on hpux 11i V1
Previous Message LLC 2006-06-20 22:16:19 Oracle Heterogenous Services Error