Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mmortsie1
Contributor II
Contributor II

Using a Custom Connect via an Include Statement

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

2 Replies
swuehl
MVP
MVP

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
Contributor II
Contributor II
Author

Thank you  it worked using a Relative path