topic fail to connect to server in SAS Programming

fail to connect to server

rykwong — Tue, 18 Jul 2017 09:28:20 GMT

I used this code to connect and import from a microsoft access file. Had been doing this for years without problem. Just installed SAS on a new windows (running windows on a mac using parallels) and got this message. Much appreciate any help to resolve this

PROC IMPORT DBMS=accesscs Out=work.history1 REPLACE

TABLE= "tbldemoandmedhistory";

DATABASE= "\\.psf\Home\Dropbox (Partners HealthCare)\BWH Cardiac MR\Grants Application\PIZ\data_analysis\Results\Access Database\Final Release of db063009 - BH June 24 2014.mdb";

RUN;

Re: fail to connect to server

AndrewHowell — Tue, 18 Jul 2017 10:20:17 GMT

Some questions to get things started and help narrow down the cause:

Forgetting SAS for a moment, can your new "Windows on a MAC" access the network path to the MS-Access file?
What version of SAS did you install, and what did you have previously (including version and 32/64-bit)?
What version of MS-Office did you install, and what did you have previously (including version and 32/64-bit)?

Re: fail to connect to server

ChrisNZ — Tue, 18 Jul 2017 10:46:55 GMT

As @AndrewHowell said, can you see folder

\\.psf\Home\Dropbox (Partners HealthCare)\BWH Cardiac MR\Grants Application\PIZ\data_analysis\Results\Access Database

from your windows explorer?

Re: fail to connect to server

Kurt_Bremser — Tue, 18 Jul 2017 12:02:14 GMT

Looks to me as if the leading dot in your hostname causes confusion in some part of the chain that resolves the UNC.

Re: fail to connect to server

rykwong — Fri, 28 Jul 2017 23:30:48 GMT

thanks everyone very much

It turns out I need to install PC file server and the problem resolved

many thansk