topic Re: Sense Desktop Connection string in App Development

Sense Desktop Connection string

mlatabhi — Wed, 28 Mar 2018 12:46:05 GMT

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

Re: Sense Desktop Connection string

dwforest — Wed, 28 Mar 2018 18:39:08 GMT

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.

Re: Sense Desktop Connection string

mlatabhi — Thu, 29 Mar 2018 16:11:30 GMT

desktop version does not support variable connection strings?

Re: Sense Desktop Connection string

mlatabhi — Thu, 29 Mar 2018 16:16:10 GMT

i meant ..

I do have a lib connection string

lib CONNECT TO '$(vConnectionString1)';

Re: Sense Desktop Connection string

dwforest — Thu, 29 Mar 2018 17:27:15 GMT

Qlik Sense does not