topic Re: ODBC Connection Error with SAS EG in SAS Enterprise Guide

ODBC Connection Error with SAS EG

jkwan — Thu, 10 Nov 2016 14:51:58 GMT

Hi,

Just hoping someone would be able to help with this. I created a ODBC connection and am able to make the connection with Base SAS, but when I try and run it in SAS EG I receive an error message.

Base SAS Code: libname BMITPRD odbc dsn=CFPRD schema=dbo; run;

SAS EG Code: LIBNAME BMITPRD ODBC DSN="CFPRD" schema=dbo;

I get the following error message when I try and run in EG:

ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Data source name not found, and no default driver
specified
ERROR: Error in the LIBNAME statement.

Any help or guidance would be appreciated.

Thanks

Re: ODBC Connection Error with SAS EG

Kurt_Bremser — Thu, 10 Nov 2016 15:03:26 GMT

Is it possible that you use Base SAS locally on your desktop, while the workspace server used in EG is run on a remote server?

Re: ODBC Connection Error with SAS EG

jkwan — Thu, 10 Nov 2016 15:06:28 GMT

I believe that is the case. Would this prevent me from being able to run the ODBC connection through EG.

Re: ODBC Connection Error with SAS EG

Kurt_Bremser — Thu, 10 Nov 2016 15:10:59 GMT

@jkwan wrote:
I believe that is the case. Would this prevent me from being able to run the ODBC connection through EG.

Yes. What you need is a similar ODBC definition on the server, which will most probably require support by the server admin. And it might need the installation of a proper client for your ODBC target on the server.

ODBC definitions do not automatically propagate in a network, but must be configured explicitly on each host.

Re: ODBC Connection Error with SAS EG

ballardw — Thu, 10 Nov 2016 15:11:49 GMT

@jkwan wrote:
I believe that is the case. Would this prevent me from being able to run the ODBC connection through EG.

Yes as your ODBC definition is local. To use EG through that server you would have to have the ODBC linked defined in such a way that the server sees it. You may need to get your SAS admin and IT folks together on possibly solutions such as placing the data source in location that the server has appropriate access to and establishing the connection.

Re: ODBC Connection Error with SAS EG

jkwan — Thu, 10 Nov 2016 15:12:45 GMT

Awesome, thanks for the help.

Re: ODBC Connection Error with SAS EG

jkwan — Thu, 10 Nov 2016 15:13:03 GMT

Thanks for the help :).