开发者

linked server Error

开发者 https://www.devze.com 2022-12-08 04:03 出处:网络
following error occur when i try to insert record from SQL server 2000 to SQL server 2005, while select query is running fine

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

精彩评论

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

关注公众号