select statement refers to the wrong datasource

Tue, 04 Jun 2013 10:07:38 GMT

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?

Re: select statement refers to the wrong datasource

montero91 — Tue, 04 Jun 2013 15:15:14 GMT

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

topic select statement refers to the wrong datasource in QlikView

select statement refers to the wrong datasource

Re: select statement refers to the wrong datasource