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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Cannot wrap stored procs in transaction via sql server



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







Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group