RE: DB2 Connect error

        No.  Tcp/ip is a protocol.  Services which use tcp/ip are assigned ports.  Telnet is assigned port 23, http is assigned port 80, ftp ports 20 and 21, etc.  There are 65535 ports available under tcp/ip and whatever service the DB2Connect client connects to on the 400 has to be assigned one of them.  Your DB2Connect client has to know what port it's supposted to use to connect the 400.  This info might be contained in an .ini file associated with DB2Connect or it might be in the Windows registry file.  To see what services are active on your 400 and what ports they're using, type NETSTAT *CNN on a command line.

Guy Murphy - FACTS system
University of Illinois
217-333-8670

-----Original Message-----
From: Wayne Capwell [mailto:wayne@redoaktech.com]
Sent: Wednesday, July 21, 1999 9:09 AM
To: MIDRANGE-L@midrange.com
Subject: Re: DB2 Connect error

According to the installation manual, DB2Connect runs over TCP/IP with
no other products required on the 400 side.  The client does ask for a
port number during the installation.  Is there a default port number for
the AS/400 TCP/IP?

> "Murphy, Guy" wrote:
>
>         We don't use this product but what the hell, I'll take a guess
> at yout problem.  Is there an AS/400 component that has to be running
> when you connect?  Does it have the same port assignment that your
> client expects?
>
> Guy Murphy - FACTS system
> University of Illinois
> 217-333-8670
>
> -----Original Message-----
> From: Wayne Capwell [mailto:wayne@redoaktech.com]
> Sent: Tuesday, July 20, 1999 6:48 AM
> To: midrange
> Subject: DB2 Connect error
>
> Hello again,
> I tried this post on Friday and got no response.  Am I the only one
> attempting to use DB2 Connect?  I'll try this again and hope for some
> help.
>
> I am attempting to connect a Win95 workstation to our AS/400 running
> V4R2 using IBM's DB2 Connect Personnel Edition over TCP/IP.  I can
> ping
> the AS/400 and have network access to the AS/400 from other Win95 PC's
>
> on the same network using Client Access.  I get the following error
> message when I try to search of a database on the AS/400.
> _________________________________________________
> The connection test failed.
>
> [IBM][CLI Driver] SQL30081N  A communication error has been detected.
> Communication protocol being used: "TCP/IP".  Communication API being
> used: "SOCKETS".  Location where the error was detected: "".
> Communication function detecting the error: "gethostbyname".  Protocol
>
> specific error code(s): "*", "11002", "*".  SQLSTATE=08001
> ____________________________________________________