Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

ODBC failed to connect to SQL VIEW

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.