topic Re: Protocol Error in TDS Stream in QlikView

Protocol Error in TDS Stream

Anonymous — Mon, 17 Nov 2014 09:59:03 GMT

Hi All,

I Have upgraded my Qlikview server and Desktop from Version Qv 11 Sr 2 to Qv 11 Sr 9.

After this change some of my reloads of Application are failing from QMC at Stage1 (which means When I am fetching the data from Database SQL).

When I am Trying to fetch the data 1st time it fails giving the following Error:

SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream

SQL SELECT *

FROM AirReconLive.dbo."tbl_SalesHeader"

2nd time when I reload it , it Succeeds without giving any error.

Please help !!!!

Regards

Erika

Re: Protocol Error in TDS Stream

Mon, 17 Nov 2014 17:51:39 GMT

Hi,

I got the similar issue here and will investigate further...

Re: Protocol Error in TDS Stream

Mon, 17 Nov 2014 21:23:32 GMT

Hi,

This is what I heard from Qlik Support below. So, update the ODBC Driver to the Latest one and it should help...

Re: Protocol Error in TDS Stream

jpapador — Mon, 17 Nov 2014 21:29:39 GMT

This issue is really annoying. Like the replies above it is an ODBC driver issue. Try updating the driver or connecting via OLEDB and see if the issue persists.

Re: Protocol Error in TDS Stream

schivet — Wed, 14 Jan 2015 10:37:06 GMT

Hi Erika,

I had exactly the same problem. Now I have updated the ODBC Driver and it work as before:

Re: Protocol Error in TDS Stream

Wed, 14 Jan 2015 10:43:45 GMT

Hi friend.

I had the same problem. I think the issue is about the ODBC Drive. Try to connect using OLEDB direclty.

This solved my problem.

See ya!

Re: Protocol Error in TDS Stream

Anonymous — Fri, 02 Oct 2015 13:49:45 GMT

Hi,

Updated the driver, but no succes...
It keeps giving the same error.

SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream

With the Debugger on it gives a little bit more information,

SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream: SQL SELECT * FROM topdesk.dbo.incident WHERE status <>'-1'

It is more but still not enough to get it sorted.

Any ideas ... can't find a solution online.

Re: Protocol Error in TDS Stream

Anonymous — Mon, 05 Oct 2015 07:08:32 GMT

Hi,

I've been fiddling with this the rest of the weekend.

And I moved to OLE DB in stead of ODBC and that works like a charm...

I guess... ODBC is just not the way to go.

gr.

Armin

Re: Protocol Error in TDS Stream

nedcliqs — Tue, 31 Oct 2017 13:11:07 GMT

I was struggling with the same error, OLE DB worked. Thanks arminkorb‌