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.
