I am working on a 64-bit machine with 32-bit Microsoft office and 32-bit odbc drivers. I used 32-bit version of ODBC Data Source Administrator to create by DSN to connect to a local copy of Microsoft Access database. When I run following code, I get an error:
libname msaccess odbc dsn=myDSN;
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.
Is there a way I can specify in libname that i want to use 32-bit odbc? We also don't have Microsoft Access PC/File access to use proc import. I will really appreciate any feedback.
We are having the same issue. We have SAS 64-Bit installed on a Win2k8R2 x64 machine. When trying to import data from any MS file (Excel, Access, etc) there is the "ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" issue.
Here's what I found out.
It looks like SAS polls the default ODBC driver locations, which is fine for an x86 environment. However, in an x64 environment, the default location is for the x64 drivers in which MS hasn't released 64 bit ODBC drivers for their office programs.
The x86 ODBC drivers do exist and are located on the server. I need to run the x86 ODBC manager to find and see them, but they are there. How can I change SAS to poll an alternative or multiple locations when opening an ODBC stream?
EDIT: We do NOT have SAS PC Files Server installed.
Message was edited by: JimmyITCS