开发者

linked server Error

following error occur when i try to insert record from SQL server 2000 to SQL server 2005, while select query is running fine

OLE DB provider "SQLNCLI" for linked server "insight_db" returned message "Protocol error in TDS stream". OLE DB provider 开发者_如何学Python"SQLNCLI" for linked server "insight_db" returned message "Communication link failure". Msg 10053, Level 16, State 1, Line 0 TCP Provider: An established connection was aborted by the software in your host machine.


If the insertion is convoluted can you do it with a stored procedure? Minimise the size of the chunk of info passing between DBs. Then check the network traffic: is the link being overwhelmed with competing "stuff" ?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜