Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

brijeshma
Contributor

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
Contributor III

Re: Error while loading data from sql server in Qliksense application

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

awhitfield
Esteemed Contributor

Re: Error while loading data from sql server in Qliksense application

And is your database really called 'Databasename' ?

Andy

brijeshma
Contributor

Re: Error while loading data from sql server in Qliksense application

Hi Roger and Andrew,

Table and database name i have Only changed..

please can u tell me why i m getting this error

Community Browser