linux信号灯已超时时间,TCP 提供程序: 信号灯超时时间已到

作者：神奇cpp | 2024-07-27 22:16:37

踩

a transport-level error has occurred when receiving results from the server.

server system versions is sql server 2008 R2+ WIN 2008 R2 , when excuting a query ,alway occur a error ,the error detail as follows:

Msg 64, Level 20, State 0, Line 0

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

Sevaral time it happand but some time all data come in secound.

else , from host romting to target server excuting a querey , when return row is more ,about more than 200 thousand ,sometimes has errors ,detail as follows :

OLE DB provider "SQLNCLI10" for linked server "ServerName" returned message "The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted.".

OLE DB provider "SQLNCLI10" for linked server "ServerName" returned message "Protocol error in TDS stream".

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider "SQLNCLI10" for linked server "ServerName"

the sql is:

SELECT * FROM [192.168.0.181].[TopSystem].dbo.tb_orders vo

WHERE vo.trade_id IN

(

SELECT trade_id FROM [192.168.0.181].[TopSystem].dbo.tb_Trade WHERE pay_time>=DATEADD(DAY,-60,GETDATE())

)

how resolving the problem ? thanks

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/神奇cpp/article/detail/891871