ODBC Connection Error with SAS EG

[jkwan]

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

[Kurt_Bremser]

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]

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

[Kurt_Bremser · Accepted solution]

---

@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]

Awesome, thanks for the help.

[ballardw]

---

@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.

[jkwan]

Thanks for the help :).