I,m working on a PC with Windows 7 and Office 2007.
I´ve tried using the exemples on the Usage Note 33228 and I´m still geting an error message.
I´v found that my port is 8561, the SASSERVERNAME = 'Local' and the SASHOSTNAME = 'localhost'. I tried to run;
proc import dbms=accesscs out=AV1 replace table="SAS_1rot";
database="D:\Home\Tania\Bases de Dados Eucalipto\Alto do Vilão\Eglob_AVilao.mdb";
But I get:
ERROR: Failed to connect to the Server: local.localhost.com.
If I run:
libname crown pcfiles server='local.localhost.com' port=8561
path="D:\Home\Tania\Bases de Dados Eucalipto\Alto do Vilão\Eglob_AVilao.mdb";
ERROR: Unable to connect to server. Please examine the pcfiles.log file for more information.
ERROR: Error in the LIBNAME statement.
For using your local machine and using an installed ACCESS database, there is not likely to be a sub-domain "local." so you should only use either "localhost" or "0.0.0.0" which you should be able to PING on your machine.
I´v tried that and I´m still geting the same error message.
I´ve been doing some research in my computer and I have "SAS/ACCESS Interface to PC Files" licensed and instaled, but I do not have the SAS PC Files Server. Could that be the problem? And if so, how do I get it?