I cant to export a file Access Database, connection failed error

[Felixmb]

I'm having a bit of trouble with SAS Enterpise Guide to export  a Access database.  I'm running 64-bit Windows, 32-bit SAS.  I've downloaded the PC File Server.  I am using the next code.   

proc export
data=work.rr_if
outtable='ACCESS'
dbms=ACCESS replace;
database='D:\Users\martin\Desktop\prueba.mdb';
run;

When i run the program, i get "Connection Failed.  See log for details." I need more details.

Someone can i help me?.

Thanks, Felix.

[naveenraj]

Check whether the PC File Server process is running.

If possible post the complete error message.

[Felixmb]

I have checked that PC File Server is running. First i checked in the control panel, administrative tools, services, SAS PC... and your state is runnig, and then i opened the application without errors.

[RW9]

And what does the log say?

[Felixmb]

15 proc export
16 data=work.rr_if
17 outtable='ACCESSCS'
18 dbms=ACCESS replace;
19 database='D:\Test.mdb';
20 run;

Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

I have modificated the code, and i runned the program, and appear the same error, what i do wrong?

[BrunoMueller]

Hi

In order to use the SAS PC File Server with Proc EXPORT, you need to use dbms=ACCESSCS instead of dbms=ACCESS, see also code below.

proc export
  data=sashelp.class
  outtable='fromSAS'
  dbms=ACCESSCS
  replace
;
  database='c:\temp\sample.mdb';
run;

Bruno

[Felixmb]

hi, is i use the same code, the program run successful, however i cant´t access to file, windows dasen´t find the file, but i run the program change the database, i see again the same error, connection failed...
Thanks

[ballardw]

Try changing

database='D:\Test.mdb';

to

database='D:\Test.accdb';

The file extensions changed.

[Felixmb]

I have changed the extension, but i always see the same error, connection failed.... Thanks