topic Re: I cant to export a file Access Database, connection failed error in SAS Enterprise Guide

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

Felixmb — Fri, 15 Jul 2016 07:48:49 GMT

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.

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

naveenraj — Fri, 15 Jul 2016 08:48:36 GMT

Check whether the PC File Server process is running.

If possible post the complete error message.

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

RW9 — Fri, 15 Jul 2016 08:57:08 GMT

And what does the log say?

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

BrunoMueller — Fri, 15 Jul 2016 09:39:53 GMT

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

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

Felixmb — Fri, 15 Jul 2016 10:10:20 GMT

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.

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

Felixmb — Fri, 15 Jul 2016 10:13:21 GMT

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?

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

Felixmb — Fri, 15 Jul 2016 10:16:35 GMT

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

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

ballardw — Fri, 15 Jul 2016 14:50:49 GMT

Try changing

database='D:\Test.mdb';

database='D:\Test.accdb';

The file extensions changed.

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

Felixmb — Mon, 18 Jul 2016 09:32:34 GMT

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