topic Re: Include using relative path issue in QlikView

Include using relative path issue

Mahamed_Qlik — Tue, 16 Jul 2019 09:32:48 GMT

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 :

$(Inlcude= ..\Includes\Connection.txt);

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];

Please help asap.

Re: Include using relative path issue

marcus_sommer — Tue, 16 Jul 2019 12:04:39 GMT

There is a typo within your include-statement:

$(Inlcude= ..\Includes\Connection.txt);

Re: Include using relative path issue

Mahamed_Qlik — Tue, 16 Jul 2019 12:48:05 GMT

Sorry i was type within my query only..

I have checked and it is corrected in application but still same issue

Re: Include using relative path issue

marcus_sommer — Tue, 16 Jul 2019 15:31:20 GMT

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.

- Marcus

Re: Include using relative path issue

Brett_Bleess — Thu, 08 Aug 2019 15:59:29 GMT

Here is Help link to Include, Marcus is correct in his explanation of things as well.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/SystemVariables/Include.htm

Here is a Microsoft link regarding relative paths as well:

https://docs.microsoft.com/en-us/dotnet/standard/io/file-path-formats

Regards,
Brett