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

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

pgsql-odbc by date

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

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