Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

How do I load already written SQL

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

1 Reply
Not applicable

could you past your sql code here?

i mean whole script (conection string also)