Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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.

Partner
Partner

desktop version does not support variable connection strings?

Partner
Partner

i meant ..

I do have a lib connection string

lib CONNECT TO '$(vConnectionString1)';

Specialist II
Specialist II

Qlik Sense does not