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

[theresaa]

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. 

[Anonymous]

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.

[theresaa]

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!

[Anonymous]

Split extraction in smaller QVDs.

[theresaa]

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.......

[Anonymous]

Or export to CVS outside QV first....

Or better generate QVD outside QV.

[Anonymous]

Never use ODBC if you can use OLEDB

[Anonymous]

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