Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
brijeshvma
Partner - Creator
Partner - Creator

Error while loading data from sql server in Qliksense application

Hi ,

i am creating one application . in that i am loading data from Sql Server . i created ODBC connection and also tried with

Qlik ODBC Connector . but i am getting an error as below:

Started loading data

Connecting to (server_qliksense) Connected

The following error occurred:

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

The error occurred here:

SQL SELECT * FROM DatabaseName.dbo."Table Name"

Data has not been loaded. Please correct the error and try loading again.

3 Replies
roger_stone
Creator III
Creator III

Is the table you are accessing really called "Table Name"?

awhitfield
Partner - Champion
Partner - Champion

And is your database really called 'Databasename' ?

Andy

brijeshvma
Partner - Creator
Partner - Creator
Author

Hi Roger and Andrew,

Table and database name i have Only changed..

please can u tell me why i m getting this error