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:
Hi, use the OLEDB method instead ODBC and try.
Even if the OLEDB refers the ODBC DSN
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);