March 2, 2004 at 4:30 am
Dear all,
I have been struggling for the last couple of days to make my SP to work. The problem is as follows:
A SP has a BEGIN TRANSACTION .. COMMIT TRANSACTION block of statements. These statements (exec SPs) basically access a remote server - behind a firewall - using OPENROWSET function and exchange data between the calling MSDE Server and the remote SQL 2000 Server. The DTC service is running on both machines. However, I do get the following error:
Error Number: -2147217900
Error Description: [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
Posting this problem on T-SQL forum I received the suggestion that the DTC service should be enabled for Network Access. However, searching for help on this matter bring no results as everything referred to Windows 2003 while both of my machines are running on Windows 2000.
Any help / ideas are greatly appreciated.
Thanks & regards,
Andreas
March 3, 2004 at 12:17 am
Hi Andrea,
I don't know if this is going to help you but once i had the same problem between two linked servers i was using. I was trying to insert, update or delete records from one server to another for some tables. A specific table kept failing and i couldn't figure out what was going wrong. Finally i found out that the problem was that i had changed the schema to one of the two tables and the other -for some reason- wasn't updated. I then added a dummy column to the table i was using -on both servers-, saved the table and then delete the dummy column. This action updated the schema of the database and everything went fine since then. If i remember correctly dropping the linked server and recreating didn't make any difference.
Hope this helps.
Dimitris
...
March 3, 2004 at 1:26 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply