Pass-through facility SQL access

[KarimTassine]

Hello everyone!

I am trying to connect my database in SAS studio using an sql pass-through facility. 

But everytime i run the program, i get this error :

ERROR: The SERVER= option is required for establishing a connection through the SAS/ACCESS Interface to PC Files.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

So, i am wondering if this issue is only on SAS studio and SAS Academic Edition!

Thank you.

[ballardw]

You may get a better response showing the actual code submitted.

And which SQL source you want to connect to.

[KarimTassine]

Thanks for reply.

this is a part of the code :

proc sql;
connect to pcfiles(path="&path\database\all.accdb"
dbpassword=sastest);
select DEALID, Duration, Score, Decision
from connection to pcfiles
          (select top 10, DEALID, Duration, Score, Decision
          from clients
          where score is not null
          order by score desc);
disconnect from pcfiles;
quit;

[Anand_V]

If you are trying this on SAS University Edition PCFILES server not supported. See the link below:
https://communities.sas.com/t5/SAS-Programming/pcfiles-serverr-with-SAS-University-Edition/td-p/2440...