Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Sense Desktop Connection string

I have done extensive research on variable connections strings and have tried many ways to get connection load tables I continue to get error when running debug No qualifed path for file:****

We use Windows Integrated security connection

SET vMyServerName = (sql server Microsoft OLE DB Provider for SQL Server)

SET vMyDatabaseName = 'dbo';

SET vMyCatalogName = '(catalog name)';

Set vConnectionString1 = OLEDB CONNECT TO [Provider=SQLOLEDB;Integrated Security=SSPI;Data Source=$(Server_name);Initial Catalog=$(Catalog_Name);Database=$(dbo)';

LOAD * FROM '$(vMyServerName)'.'$(vMyDatabaseName)'.'$(vMyCatalogName)'.'table_nm';

4 Replies
Highlighted
Specialist II
Specialist II

Sense doesn't support setting of Connections in Standard Mode. Create the connection and then connect or load from it.

for OLE DB connections, you would have a

LIB CONNECT TO 'yoursource';

Then any load would reference data available from that data connection definition. Only one connection is active at a time.

Highlighted
Partner
Partner

desktop version does not support variable connection strings?

Highlighted
Partner
Partner

i meant ..

I do have a lib connection string

lib CONNECT TO '$(vConnectionString1)';

Highlighted
Specialist II
Specialist II

Qlik Sense does not