I'm getting the following error when trying to load data from an ODBC connection in Qlik Sense 1.1:
The following error occurred:
SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
I'm trying to use a simple statement shown here (with sensitive info hidden):
LOAD [field list];
SQL SELECT * FROM [tablename];
We have the same table on two different databases in two different servers and I'm getting the same error on both. What's strange is that I can select from another table on the same database, using the same ODBC connection with no issues at all. So I don't think it's a version conflict or a driver issue. I can also run the query in SQL server management studio just fine. It's just this one app selecting from this one table.
Could it be something with strange characters or data types? I haven't run into this issue before, though. Also of note is that I had a different app selecting from this table just fine a few weeks ago, but now that's not working either. Any help would be appreciated!