Desktop productivity for business analysts and programmers

Error using ODBC connection

Reply
N/A
Posts: 0

Error using ODBC connection

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?
Valued Guide
Posts: 2,111

Re: Error using ODBC connection

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
Community Manager
Posts: 2,696

Re: Error using ODBC connection

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
Ask a Question
Discussion stats
  • 2 replies
  • 175 views
  • 0 likes
  • 3 in conversation