topic Re: Error using ODBC connection in SAS Enterprise Guide

Error using ODBC connection

deleted_user — Wed, 10 Nov 2010 12:30:39 GMT

Hello,

I get this error when trying to connect to a MS Access database. I'm working on win2003server 64 bit. I created an odbc connection through odbcad32.exe.

1 LIBNAME ACCESREF ODBC DATASRC=rws ;
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver
specified
ERROR: Error in the LIBNAME statement.
2

Can anyone help?

Re: Error using ODBC connection

Doc_Duke — Wed, 10 Nov 2010 18:17:30 GMT

Did you create the odbc connection on the server or on your workstation. It would need to be on the server.

As a workaround, you could just use the ACCESS libname engine and skip the ODBC part.

Doc Muhlbaier
Duke

Re: Error using ODBC connection

ChrisHemedinger — Wed, 10 Nov 2010 21:11:43 GMT

If the SAS process on your server is 64-bit, then you would need a 64-bit ODBC driver.

http://support.sas.com/kb/38/779.html

Chris