Using a Custom Connect via an Include Statement

mmortsie1 — Tue, 22 Jul 2025 17:59:49 GMT

Hallo,

Im using the Qlik ODBC Connector and want to use an include statement for a Custom Connect so that i do not have to maintain the password in each project.

It works fine when im reloading the file from the Desktop App. The problem it does not work when im doing the reload via Publisher.

When i have the Custom Connect statement in the Script Direclty then the Reload works from Publisher aswell so the connector is installed correctly. I just does not work when using the Include statement

Here is the Script

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

$(Include=\\PROJ\test.txt);

LOCATION:

SELECT

FROM

LOCATION;

Statement in the test.txt file

CUSTOM CONNECT TO 'Provider=QvOdbcConnectorPackage.exe;driver=oracle;host=XXXXXX.com;port=1521;servicename=XXXXX;EnableNcharSupport=1;XUserId=XXXXXX;XPassword=XXXXXX;';

Re: Using a Custom Connect via an Include Statement

swuehl — Mon, 20 Jul 2015 12:25:52 GMT

I think your issue is due to the use of the UNC path \\PROJ\ on server in your include statement.

Try mapping the shared folder to a drive name or use a relative path instead.

Re: Using a Custom Connect via an Include Statement

mmortsie1 — Mon, 20 Jul 2015 13:03:08 GMT

Thank you it worked using a Relative path

topic Using a Custom Connect via an Include Statement in Archived Groups

Using a Custom Connect via an Include Statement

Re: Using a Custom Connect via an Include Statement

Re: Using a Custom Connect via an Include Statement