Re: OT: SQL Server- Postgres Distributed Transactions

2006-06-22 Thread Jochem van Dieten
Nick Han wrote: erver: Msg 7391, Level 16, State 1, Line 1 The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. [OLE/DB provider returned message: Unsupported connect attribute (Set)] OLE DB error trace [OLE/DB Provider

OT: SQL Server- Postgres Distributed Transactions

2006-06-21 Thread Nick Han
Does anyone know if there is a solution to making transactions work, when using remote calls from SQL Server to Postgres? We have a link server setup and we are able to push data over to Postgres from SQL Server. What we are having a problem with is when trying to wrap transactions around the

Re: OT: SQL Server- Postgres Distributed Transactions

2006-06-21 Thread Jochem van Dieten
Nick Han wrote: Does anyone know if there is a solution to making transactions work, when using remote calls from SQL Server to Postgres? We have a link server setup and we are able to push data over to Postgres from SQL Server. What we are having a problem with is when trying to wrap

RE: OT: SQL Server- Postgres Distributed Transactions

2006-06-21 Thread Nick Han
[OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 4:31 PM To: CF-Talk Subject: Re: OT: SQL Server- Postgres Distributed Transactions Nick Han wrote: Does