Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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