05-10-2016 08:44 AM - edited 05-10-2016 08:44 AM
I have MS ACCESS file with .accdb extension. It has three tables. I am trying to read one of the tables but getting error while reading it. I tried import wizard in enterprise guide. It’s working perfectly.
When I am trying to use proc import or tried reading using libname statement I am getting error.
My file is in UNIX server.
PROC IMPORT OUT= WORK.abc1
ERROR: A socket routine returned error: An unexpected error has occurred. Error number is 0.
ERROR: Failed to connect to the Server:
05-10-2016 11:20 AM - edited 05-10-2016 11:24 AM
One question only
Does your company uses firewalls or stuff like that ?
In this case, the system administrator must make a port available for the SAS PC Files Server.
This might help
05-17-2016 08:46 AM
My SAS server is grid server. I came to know that I can not import the access db ditectly to SAS GRID server. I am able import it in PC/BASE SAS using proc import and libname statement.