Specify where PC File server is located

PaalNavestad — Wed, 16 Jan 2019 15:25:49 GMT

HI, I'm trying to import tables from an access database in a Linux Environment.

I have Access to PC files installed. However when trying to import I get

ERROR: Server Name is invalid or missing.

I can't find anywhere in the documentation where I can identicate where the PC Files server is located. The code I'm trying to run is

proc import  out=ofm_data_dca_case
table="OFM_DATA_DCA_CASE"
DBMS=ACCESSCS REPLACE

;


 DATABASE="/shared/winshare/teams_no/SAS_General/subsurface/dev/GGRE_IN/OFM_Avocet.mdb";

 run;

We are running on a LINUX Grid version 9.4 M5

Re: Specify where PC File server is located

ybolduc — Wed, 16 Jan 2019 15:33:06 GMT

Hi PaalNavestad,

I believe you would have more success with the libname pcfiles engine: https://documentation.sas.com/?docsetId=acpcref&docsetTarget=n1qk7lv0f535qkn1mydookwetyrp.htm&docsetVersion=9.4&locale=en

Thanks,

Yoan

topic Specify where PC File server is located in SAS Programming

Specify where PC File server is located

Re: Specify where PC File server is located