Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group