Qlik Community

Ask a Question

Qlik Sense App Development

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

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

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
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.


desktop version does not support variable connection strings?


i meant ..

I do have a lib connection string

lib CONNECT TO '$(vConnectionString1)';

Specialist II
Specialist II

Qlik Sense does not