when running the following query on PS SAS ,EG(Remote) and UNIX with including "rsubmit" statement i am ok :
rsubmit;
proc sql;
connect to sqlsvr as mydb (datasrc=DM_UserDB user =xxx password=yyy readbuff=32767);
create table test(compress = no) as select * from connection to mydb
(SELECT COUNT(*) FROM table_name );
disconnect from mydb;
quit;
endrsubmit;
but when running it on UNIX lets say without the "rsubmit" then i get this:
ERROR: The SAS/ACCESS Interface to SQLSRV cannot be loaded. The SASSQSRV code appendage could not be loaded.
ERROR: A Connection to the sqlsvr DBMS is not currently supported, or is not installed at your site.
I thought the ODBC.ini file would take care of that. So why still the need of rsubmit if i am running this on the remote server?
... View more
