Re: Cannot wrap stored procs in transaction via sql server

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: kevin(at)kevinkempterllc(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Cannot wrap stored procs in transaction via sql server
Date: 2006-06-23 00:16:10
Message-ID: 449B32CA.20705@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message noreply 2006-06-23 02:57:16 [ psqlodbc-Bugs-1000671 ] psqlodbc does not compile on hpux 11i V1
Previous Message Ludek Finstrle 2006-06-22 16:07:28 Re: Oracle Heterogenous Services Error