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.