topic Re: SQL connection from SAS in New SAS User

SQL connection from SAS

jaiganesh — Tue, 03 Dec 2019 14:36:24 GMT

Hello,

I'm trying to get the Microsoft SQL connected to SAS, I've followed the attached document till the page number 13 , from page 4 (libname statement ) , using below code , However couldn't able to get the desired result.

Code1:

proc sql;
connect to odbc as mycon ( Datasrc='*****' USER="******" PASSWORD="*****");
quit;

ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Data source name not found and no default driver
specified

if i change "odbc " to "SQLSVR" then getting below error

Code2:

proc sql;
connect to SQLSVR as mycon ( Datasrc='*****' USER="******" PASSWORD="*****");
quit;

ERROR: The SQLSVR engine cannot be found.
ERROR: A Connection to the SQLSVR DBMS is not currently supported, or is not installed at your site.

Kindly suggest on this...

Re: SQL connection from SAS

AnandVyas — Wed, 04 Dec 2019 02:46:56 GMT

Is your SAS Session executing on the same machine where the DSN setup is configured? Usually the engine connot be found error when the session isn't able to find the DSN..

Re: SQL connection from SAS

SASKiwi — Wed, 04 Dec 2019 02:52:48 GMT

The CLI error suggests your SAS Application server is running on Unix. If that is the case, then the attached document will not be helpful as that is for SAS running on Windows.

On Unix you need to configure a file called odbc.ini. This post may be useful:

https://communities.sas.com/t5/SAS-Data-Management/Example-of-DSN-less-SQL-Server-connection-from-Linux/td-p/349245

Your SQLSVR error suggests that the SAS product SAS/ACCESS to SQL Server is not installed.

Re: SQL connection from SAS

jaiganesh — Wed, 04 Dec 2019 10:08:04 GMT

MY SAS is running on the Linux, MY DSN is configured on the Windows.

Kindly suggest.

Re: SQL connection from SAS

AnandVyas — Wed, 04 Dec 2019 11:29:48 GMT

I think you can try this doc - https://www.easysoft.com/support/kb/kb01029.html