Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 6

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

[ Edited ]

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.

Contributor
Posts: 54

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

Check whether the PC File Server process is running.

 

If possible post the complete error message.

Occasional Contributor
Posts: 6

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

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.
Super User
Super User
Posts: 7,720

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

And what does the log say?

Occasional Contributor
Posts: 6

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

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?
SAS Super FREQ
Posts: 706

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

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

Occasional Contributor
Posts: 6

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

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
Super User
Posts: 11,134

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

Try changing

database='D:\Test.mdb';

 

to

database='D:\Test.accdb';

 

The file extensions changed.

Occasional Contributor
Posts: 6

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

I have changed the extension, but i always see the same error, connection failed.... Thanks
Ask a Question
Discussion stats
  • 8 replies
  • 876 views
  • 4 likes
  • 5 in conversation