question

hans.maes1975 avatar image
hans.maes1975 asked

Error message retrieve data from linked server

I try to retrieve data from a linked server, for some tables it is working, for other I receive following error ? Anyone an idea? for a certain table it is working for some dates, but another date range gives me error below, strange, it was working always before.

OLE DB provider "SQLNCLI11" for linked server "213.xxx.xxx.xxx\NAVITRANS,58126" returned message "Protocol error in TDS stream". OLE DB provider "SQLNCLI11" for linked server "213.xxx.xxx.xxx\NAVITRANS,58126" returned message "Communication link failure". Msg -1, Level 16, State 1, Line 0 Session Provider: Physical connection is not usable [xFFFFFFFF]. OLE DB provider "SQLNCLI11" for linked server "213.xxx.xxx.xxx\NAVITRANS,58126" returned message "Communication link failure". Msg -1, Level 16, State 1, Line 0 Session Provider: Physical connection is not usable [xFFFFFFFF]. OLE DB provider "SQLNCLI11" for linked server "213.xxx.xxx.xxx\NAVITRANS,58126" 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.

linked server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.