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