Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC failed to connect to SQL VIEW

I have two tables : STORE TABLE and ORDER TABLE.

STORE TABLE has column "Store Key" and "Store Num", but ORDER TABLE only has "Store Num".

I joined "Store Key" from STORE TABLE to ORDER TABLE, but realized that each "Store Num" is linked to several "Store Key" based on "Store End Date". So I wrote a join statement in SQL then saved it as view.

But when I tried to connect to the SQL view through ODBC, it showed the following message, please help me check the following code and let me know where I did wrong , THANK YOU!!

error loading image

This is my SQL code :

error loading image

This is my ODBC connection:

error loading image

1 Reply
hector
Specialist
Specialist

Hi, use the OLEDB method instead ODBC and try.

Even if the OLEDB refers the ODBC DSN

Ex.

CONNECT TO [Provider=MSDASQL.1;Persist Security Info=True;User ID=YOUR_USER;Data Source=YOUR_ODBC;Extended Properties="DSN=YOUR_ODBC;UID=YOUR_USER;APP=QlikView;WSID=WORKSTATION_ID;DATABASE=DATABASE_NAME;";Initial Catalog=DATABASE_NAME] (XPassword is PLdTRTRMTLaGHYFMZTceGWRNaE);

C ya.