Problem Note 34098: SAS® is unable to connect to the host when specifying the host name while using the FTP/URL/Socket/EMAIL FILENAME engine
 |  |  |  |  |
When you use the FTP, URL, or SOCKET engine in SAS® 9.2 Phase 1 (TS1M0) in a FILENAME statement, you might receive the following error if the remote host's HOSTNAME cannot be resolved to a valid remote host name:
NOTE: UNABLE TO CONNECT TO HOST host name. CHECK VALIDITY OF HOST NAME. ERROR: OPEN FAILED FOR FILE file name ERROR: HOSTNAME host name NOT FOUND.
This error is likely caused by a problem with the reverse lookup function.
Select the Hot Fix tab in this note to access the hot fix for this issue.
An example for using the FTP engine would be the following:
filename lcl ftp 'test.sas7bdat' host='<host_name>' user='<userid>' prompt
cd='<Path_to_the_folder_where_test.sas7bdat_resides>' recfm=s debug;
FILENAME rmt 'c:\test.sas7bdat' recfm=n;
DATA _NULL_;
N=1;
INFILE lcl NBYTE=n;
INPUT;
FILE rmt ;
PUT _INFILE_ @@;
RUN;
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M0 | ||
| Windows Vista | 9.2 TS1M0 | 9.2 TS2M0 | ||
| z/OS | 9.2 TS1M0 | 9.2 TS2M0 | ||
A fix for SAS 9.2 (TS1M0) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/f9_sbcs_prod_list.html#034098A fix for SAS 9.2 (TS1M0) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/f9_dbcs_prod_list.html#034098
In SAS 9.2 TS1M0, if you use a filename engine, you receive the following error if the local host's HOSTNAME cannot be resolved using the host name:
NOTE: UNABLE TO CONNECT TO HOST host name. CHECK VALIDITY OF HOST NAME.
ERROR: OPEN FAILED FOR FILE file name
ERROR: HOSTNAME host name NOT FOU
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-06-12 10:34:28 |
| Date Created: | 2008-12-01 13:48:35 |