1 Reply Latest reply: Aug 18, 2009 8:56 PM by Héctor Muñoz RSS

    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

        • 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.