4 Replies Latest reply: Mar 29, 2018 1:27 PM by David Forest RSS

    Sense Desktop Connection string

    Mary Lata

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