Problem Note 42576: PC File Server generates "Failed to Connect to Server" message when the server name is longer than 32 characters
When importing files using the PC File Server the following error can be generated:
ERROR: Failed to connect to the Server:Servername.ipaddress.longname.c
The server name will be truncated in the message. The problem occurs when the
server name is longer than 32 characters in the server parameter as shown below:
proc import dbms=excelcs
out=work.test12 datafile='c:\mydir\test.xls' replace;
port=8621;
server='Servername.ipaddress.longname.com';
sheet='sheet1';
run;
To resolve the problem do one of the following:
- Replace the server= name with the IP address rather than the actual servername
- Use the second maintenance release of SAS 9.2 (TS2M2) or later where the server=parameter can be up to 255 characters.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Linux | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Linux on Itanium | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Solaris for x64 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Tru64 UNIX | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
When the server name is longer than 32 characters the PC File Server
will generate a failed to connect to server error in SAS 9.1.3. The problem is fixed in SAS 9.2 (TS2M2) and later.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-03-03 15:43:55 |
| Date Created: | 2011-03-02 17:44:38 |
