March 20, 2003 at 2:48 pm
I want to transfer data from one server to the other server by distributed query.I have executed the query it's status is showing active. But actually nothing is happending to find exactly what is happening from sysprocesses table i have come to know that the connection has been suspended as it is waiting for oledb provider i.e in the columns lastwaittype and waittype the value it is showing is oledb and 0X42.
Can any body guide me how to over come and get the data transferred.
March 21, 2003 at 9:30 am
Can you provide more information? Is this SQL Server to SQL Server? OR some other provider?
The provider hsa to support the inserts, which not all providers do.
Steve Jones
March 21, 2003 at 4:14 pm
Use the DTCPing utility in knowledgebase article 306843 to see if your servers have duplicate CIDs for the MSDTC. If so then that is your problem and you will need to change the CID. We had this problem about a month ago and it drove me crazy. In step 11 of the article they point out which registry key to look at to see if you have dupes.
Take a look at http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=10382 For more info.
Michelle
Michelle
March 23, 2003 at 12:08 am
Hi Steve,
Data is being transferred from one SQL Server to the other Sql Server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply