topic Garbage After Statement - Using Text File For Connection String in QlikView

Garbage After Statement - Using Text File For Connection String

pnn44794 — Wed, 25 Nov 2020 16:16:04 GMT

Hello:

Since I have multiple dashboards all using the same ID, it makes sense to me to create a text file with the connection string in it, with the ID, password, database, etc and then call that file from each dashboard using an include statement. I'm currently testing it with just one dashboard and I'm getting the "Garbage after statement error". A window pops up with that error message and once I click OK, the load script executes and I get connected to the database. However, once the dashboard goes live, it will be run as a task via QMC. Thus it will fail as you can't click OK. Here's what is stored in the text file (note some values have been changed since they shouldn't be public, i.e. Source, Catalog, Password, etc):

Let vConnectionString='{OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=USER1234;Initial Catalog=info;Data Source=my.database.server\SESSION;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CHCAR10C38N1;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is NotARealPassword)}';

Here is what I have in my load script on the Main tab. There are then other tabs that get executed. As a side note, I previously had the connection string in the load script and it ran fine.

$(Include=..\Config\DevSourcesI680656.txt);
CONNECT TO [$(vConnectionString)];

As always, any and all help is appreciated. Thanks in advance.

Re: Garbage After Statement - Using Text File For Connection String

awhitfield — Wed, 22 Mar 2017 16:48:09 GMT

Hi Perry,

just had a play, Just put the actual connection string in your .txt

e.g. my file is connect.txt

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Password=bpi;Persist Security Info=True;User ID=bpi;Initial Catalog=NHS_SLR;Data Source=(local);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CSD005779-DW7;Use Encryption for Data=False;Tag with column collation when possible=False]

then the includes statement using the insert includes statement:

$(Include=connect.txt);

and that's it.

save and reload

HTH

Andy

Re: Garbage After Statement - Using Text File For Connection String

pnn44794 — Wed, 22 Mar 2017 17:10:08 GMT

That worked. Thank you very much Andrew. The code I was using was from another thread related to using a text file to store your connection string and they used "CONNECT TO" as I had above. Removed that and I was good to go. Thanks again.