1 Reply Latest reply: Sep 10, 2012 8:09 AM by Wojciech Parzyszek RSS

    How do I load already written SQL

    Helen Pippard

      Hello

       

      I am very new to Qlikview and require some assistance

       

      I have connected to my data source by using ODBC connnection (SQL Server)

       

      However instead of loading various tables from the database, I wish to load an already existing piece of SQL I have already written

       

      How do I LOAD/CALL this already written SQL statement?

       

      I have tried simply copying the SQL statement into the edit script, but I go the following error message

       

       

      SQL##f - SqlState: 28000, ErrorCode: 18452, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection.

      ODBC CONNECT TO Live_Sym

       

      Cany anyone help me?

       

       

      Hello

       

      Thank you for your time

       

      My colleague and I were able to solve this yesturday.....It was the connections our end

       

      I have now a new problem, which I think I will post on-line in a moment

       

      Thanks

      Helen

       

      Message was edited by: helen_pip