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

    How do I load already written SQL

    Helen Pippard



      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?





      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





      Message was edited by: helen_pip