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