Sense Desktop Connection string

[mlatabhi]

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

[dwforest]

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.

[mlatabhi]

desktop version does not support variable connection strings?

[mlatabhi]

i meant ..

I do have a lib connection string

lib CONNECT TO '$(vConnectionString1)';

[dwforest]

Qlik Sense does not