My team is currently migrating from SAS Enterprise Guide to SAS Grid and I am attempting to transfer my frequently used programs to the Grid. This is how I connect to a specific server in SAS Enterprise Guide: PROC SQL;
CONNECT TO SQLSVR AS sasqrm (user=&eid_sqlconn password=&pwd_sqlconn
datasrc=servername); This connection string is not effective in SAS Grid. The code below was my best attempt at connecting to this server in SAS Grid based off of other questions asked with SAS community. When I run the code I receive this error: "ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Driver Manager Message file not found. Please check for the value of InstallDir in your odbc.ini." libname abc odbc noprompt ="uid=&eid_sqlconn; pwd=&pwd_sqlconn;dsn=servername;
DRIVER=SQL Server Native Client 11.0;
Trusted_Connection=yes" DATABASE = database_name schema = dbo; Is there an obvious error I'm making in this connection string?
... View more