topic Re: Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 61047, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream in QlikView

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

theresaa — Mon, 23 Feb 2015 17:01:34 GMT

I receive this error randomly when loading a qlikview document from an ODBC connection to a SQL Server database. It loads a random number of records, then gets this error, and sometimes it loads them all with no error.

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

Anonymous — Mon, 23 Feb 2015 17:50:31 GMT

The error message not very informative. If it happens on a "SELECT", try to run this SQL statement directly in SQL Sever, outside of QlikView script. It may give you a clearer error message.

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

theresaa — Mon, 23 Feb 2015 22:11:17 GMT

Thanks Michael. I did try your suggestion, and got an error message:

I will take this to the SQL Developers for further assistance.

Thanks again!

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

Anonymous — Tue, 24 Feb 2015 02:07:41 GMT

Split extraction in smaller QVDs.

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

theresaa — Tue, 24 Feb 2015 22:09:42 GMT

Seems like my answer to this is using OLE DB connection vs ODBC connection. Per the SQL developers, the ODBC connection is less forgiving when having to wait on a response from the SQL database, and times out. Using the OLE DB connection seems to have fixed the problem.

Caution - OLE DB brings Bit data over as -1 for True and 0 for False, ODBC brings Bit data over as 1 for True and 0 for False.......

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

Anonymous — Tue, 24 Feb 2015 22:21:11 GMT

Or export to CVS outside QV first....

Or better generate QVD outside QV.

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

Anonymous — Tue, 24 Feb 2015 23:12:54 GMT

Never use ODBC if you can use OLEDB

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

Anonymous — Wed, 25 Feb 2015 01:36:53 GMT

and use 64 bits version if you can use it....