I want to connect qlikview to my database using my connection string.
But, I want to save connection string in txt and i want to call this txt file in inlcude as below :
So issue is, when I execute above script it is throwing an error of " there is no open data connection" but when I dont use this connection string txt file and I write full path as below then my script got executed correctly.
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=xxxxxxxxx;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=xxxxxxx;Use Encryption for Data=False;Tag with column collation when possible=False];
Then it seemed that your relative path isn't valide. The easiest way to get the proper relative path is to use the file-wizard with the enabled option to apply relative paths to load the include-file as a flat-file. You don't need to execute this load - just copy & paste the path from the from-statement and then remove the whole thing again.
Further useful is the use of must_include instead of include because then you will get an error-message if the access to the file failed.