ODBC failed to connect to SQL VIEW

[#1]

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!!

This is my SQL code :

This is my ODBC connection:

[hector]

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.