How do I load already written SQL

helen_pip — Mon, 10 Sep 2012 11:37:42 GMT

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

Re: How do I load already written SQL

Mon, 10 Sep 2012 12:09:55 GMT

could you past your sql code here?

i mean whole script (conection string also)

topic How do I load already written SQL in QlikView

How do I load already written SQL

Re: How do I load already written SQL