Error using ODBC connection

[deleted_user]

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?

[Doc_Duke]

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

[ChrisHemedinger]

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