Re: Getting an AS/400 Printout into Excel...

[Pete Hall <peteh@xxxxxxxxxx>]

At 10:47 AM 6/30/98 -0400, Chuck Lewis wrote:
>I tried starting FTP (and I am a real NOVICE when it comes to stuff like this 
>on
>the AS/400) and I get "cannot connect to host xxxxxx.xxx.xxx.COM (where all the
>x's are valid names) at address xxx.xx.xx.x. (where all the x's are valid
>numbers) try again.
>
>I can ping the AS/400 and I am connecting to the AS/400 via TCP/IP at my NT
>Workstation. Host Servers is started (has to be started for me to connect via 
>CA
>or I get an error), etc.

Chuck,

This is not necessarily true. It depends on how the host servers are started. 
If they are started with the STRTCP command (V4R2), only the servers that are 
configured to start automatically will be active. Try starting the FTP server 
explicitly with STRHOSTSVR. After it runs, check your joblog. It will contain a 
message about duplicate prestart job entries if the FTP server is already 
running. Either way, it will not do any harm and FTP will be started when it 
completes. Don't forget that the public authority for STRHOSTSVR as shipped 
from Rochester is *EXCLUDE. Also, just in case, make sure you have the AS/400 
defined in the HOSTS. table on your PC, although from your description, it 
seems that you already do. When you connect via C/A, are you using TN5250? If 
so, the connection is (except for the port) the same as FTP. I would suspect 
either an authority problem (check QSYSMSG message queue for authority 
exceptions) or an exit program, or maybe a nonstandard port.

When I start command line FTP, it usually goes (approximately) something like 
this:

Me: FTP myhostname.com
FTP: Enter user ID
Me: MyUserId
FTP: Enter Password
Me: MyPassword
FTP: Login Successful.

Don't you just love having all this new stuff to figure out? The really cool 
part is that when you finally get it working, it works great!!!

hth
Pete


Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---