Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-13 : 09:44:30
|
| Christine writes "I am trying to copy data from a server outside our firewall to a server on our intranet using the following SQL:'INSERT tbl_shopping_transaction EXECUTE EPEGServer...sp_ECommerce_ShoppingTransaction_DownloadToIPEG 'DownloadStart', @record_count OUTPUT'I get this message 'Server: Msg 7391, Level 16, State 1, Line 7The operation could not be performed because the OLE DB provider 'SQLOLEDB' does not support distributed transactions.[OLE/DB provider returned message: Distributed transaction error]'EPEGServer is the external server and is defined as a linked server. If I remove the 'Insert' statement then the query works fine. The above SQL works fine on two linked test servers where there is no firewall involved.We are running SQL Server v7 on windows NT 4 SP6 and using TCP/IP. Both DTC and RPC are running on EPEGServer." |
|
|
|
|
|
Distributed Transactions