Re: OT: SQL Server- Postgres Distributed Transactions
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 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]. Which PostgreSQL version? What is in the PostgreSQL log file? Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244523 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: SQL Server- Postgres Distributed Transactions
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 calls, the transaction fails. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:20 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: SQL Server- Postgres Distributed Transactions
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 transactions around the calls, the transaction fails. Are you using 2-phase commit? Which versions? What error? Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244493 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: SQL Server- Postgres Distributed Transactions
Jochem, This is the error msg I get, 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 '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 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 calls, the transaction fails. Are you using 2-phase commit? Which versions? What error? Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244502 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54