Cannot wrap stored procs in transaction via sql server link

Cannot wrap stored procs in transaction via sql server link

am 21.06.2006 02:04:39 von LLC

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...



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Cannot wrap stored procs in transaction via sql server

am 23.06.2006 02:16:10 von Hiroshi Inoue

LLC wrote:
> 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 ?

Could you try the dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?

regards,
Hiroshi Inoue





---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match