Learning SAS? Welcome to the exclusive online community for all SAS learners.

Error when trying to connect to PC File Server from University Edition

Reply
Occasional Contributor
Posts: 7

Error when trying to connect to PC File Server from University Edition

I am trying to execute a libname statement to establish a connection to a relational DB using an ODBC DSN.  Here's the program:

 

libname WWI pcfiles
server='WIN-Pro'
dsn='WorldWideImporters'
schema=Purchasing
;

Here's the resulting log:

 
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
61
62 libname WWI pcfiles
63 server='WIN-Pro'
64 dsn='WorldWideImporters'
65 schema=Purchasing
66 ;
ERROR: Unable to resolve host name specified by SERVER=.
ERROR: Error in the LIBNAME statement.
67
68 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
81
 

Both SAS University Edition and the SAS PC File Server are installed on the same PC, WIN-Pro 

Super User
Posts: 19,770

Re: Error when trying to connect to PC File Server from University Edition

Posted in reply to PaulOldenKamp

PC File Server is not officially supported in SAS UE. 

Occasional Contributor
Posts: 7

Re: Error when trying to connect to PC File Server from University Edition

Reeza, I don’t think that your answer is correct.

 

University edition includes SAS/ACCESS Interface to PC Files, the PCFILES engine.  This allows one to connect to the SAS PC File Server.  The SAS website has documentation of this:

 

 http://support.sas.com/documentation/cdl/en/acpcref/69731/PDF/default/acpcref.pdf See page 213

 

http://support.sas.com/documentation/cdl/en/acpcref/69731/HTML/default/viewer.htm#n1qk7lv0f535qkn1my...

 

Last year there was a posting by Ksharp to the SAS Analytics U Community Forum that described what I want to do:

 

https://communities.sas.com/t5/SAS-Analytics-U/Connect-to-SQL-Server-Oracle-Database-by-SAS-Universi...

 

I myself got it working last year when I was using University Edition on a Windows 7 computer with earlier versions of UE and the PC Files Server.  I am now using a Windows 10 Pro computer and the latest versions of UE and PC Files Server and it can’t resolve the value in the server= libname option.

Super User
Posts: 19,770

Re: Error when trying to connect to PC File Server from University Edition

[ Edited ]
Posted in reply to PaulOldenKamp

It can be made to work is my understanding, but there is no official support for attempting to connect SAS UE to a server AFAIK. SAS Support can respond tomorrow to clarify. 

 

Edit: Note that I've stated it's not officially supported, not that it cannot be done. Here's why:

https://communities.sas.com/t5/Base-SAS-Programming/pcfiles-serverr-with-SAS-University-Edition/m-p/...

https://communities.sas.com/t5/SAS-Analytics-U/ORACLE-connection/m-p/244091#U244091

 

Also, did you remember to add the server to the dsn entries on your computer? 

Ask a Question
Discussion stats
  • 3 replies
  • 336 views
  • 0 likes
  • 2 in conversation