Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

select statement refers to the wrong datasource

I used the connect wizard to make a connect statement:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=user;Initial Catalog=DATABASE;Data Source=SQL;

Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SQL;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is cHIOMSFPOTLA);

When I use the Select button to select tables this works the first time. But when I save and close the script, open it again, and then use the select button to select tables the program suddenly refers to another datasource (server). This is the datasource I used when I created the script for test purposes. The weird thing is that I don't have that datasource in my script anymore. Am I forgetting something?

1 Reply
Highlighted
Creator
Creator

At the end of the query Applies the "Disconnect". might please the connection is still alive