Dear all , I want to connect to a sql server db ( on another server ). I'm not using DSN names , the sql server db uses windows authentification. Statement : libname sdmlib SQLSVR 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abcde;Data Source=datasourcenameab;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=wsid;Use Encryption for Data=False;Tag with column collation when possible=False'; ( data source name , workstation id and catalog are example values ) Error : ERROR: Incorrect syntax for this LIBNAME statement. This engine does not accept a physical name. ERROR: Error in the LIBNAME statement.
... View more