Problem Note 36967: A failure-to-connect error occurs when you use the SAS® PC Files Server and you set the PORT= option to a value greater than 10000
 |  |  |  |
When you use the EXCELCS, ACCESSCS, PCFILES, or SASIOPCF engines with the SAS PC Files Server, you can receive the following error:
ERROR: Failed to connect to the Server: yourserver.com.
This error occurs when you set the value for the PORT= option to 10000 or greater, as shown in the following example:
proc export dbms=excelcs data=sashelp.class
outfile="c:\sastest\myclass.xls" replace;
sheet=class;
server="yourserver.com";
port=10000;
run;
The problem occurs because of a memory-address issue in the SAS PC Files Server. To circument the problem, set the PORT= option to a value of 9999 in your SAS code.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.3 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.3 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.3 TS1M0 | ||
| Linux | 9.1 TS1M3 | 9.3 TS1M0 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.3 TS1M0 | ||
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Access Data Management ==> Data Sources ==> External Databases ==> MS Excel |
| Date Modified: | 2009-10-21 13:07:38 |
| Date Created: | 2009-08-25 09:35:44 |