Desktop productivity for business analysts and programmers

ODBC Connection Error with SAS EG

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

ODBC Connection Error with SAS EG

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


Accepted Solutions
Solution
‎11-10-2016 10:13 AM
Esteemed Advisor
Posts: 6,646

Re: ODBC Connection Error with SAS EG


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Esteemed Advisor
Posts: 6,646

Re: ODBC Connection Error with SAS EG

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?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: ODBC Connection Error with SAS EG

I believe that is the case. Would this prevent me from being able to run the ODBC connection through EG.
Solution
‎11-10-2016 10:13 AM
Esteemed Advisor
Posts: 6,646

Re: ODBC Connection Error with SAS EG


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: ODBC Connection Error with SAS EG

Awesome, thanks for the help.
Grand Advisor
Posts: 10,210

Re: ODBC Connection Error with SAS EG


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.

New Contributor
Posts: 4

Re: ODBC Connection Error with SAS EG

Thanks for the help Smiley Happy.
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 212 views
  • 0 likes
  • 3 in conversation