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
@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.
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?
@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.
@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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.