Using a Custom Connect via an Include Statement

[mmortsie1]

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

[swuehl · Accepted solution]

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.

[mmortsie1]

Thank you  it worked using a Relative path