Accessing MS SQL Server database from the iSeries
AS/400, SQL database, SQL Server
How to set up TCP/ IP on both ends( SQL server and AS/400)?I keep geting "host name not found" on as400.
Thanks,
Lan
Question
AS/400, SQL database, SQL Server
How to set up TCP/ IP on both ends( SQL server and AS/400)?I keep geting "host name not found" on as400.
Thanks,
Lan
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
I think we need some more detail.
Do you have TCPIP set up on the AS/400?
Can you ping the IP Address of the AS/400 from another server or PC?
From which box are you getting the error message?
When you go into the TCP/IP Settings do you see that IP you have configured as Listening or Enable or off?
You need to make sure you have TCPIP Started on the AS/400. STRTCP command will fire it up.
Also what version of OS/400 are you running?
Browse more Questions and Answers on AS/400 and SQL Server.
Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
The ‘host name not found’ error suggests that the AS400 is not able to resolve the server name to an IP address.
This is usually because there is no DNS server in your network and/or the remote system has not been defined in your AS400’s host table.
Try pinging the IP address of the SQL server from the AS400.
If this works, and you do not have a DNS server set up in your network, you will need to add the SQL server’s details to the hst table on the AS400:
enter command CFGTCP
take option 10, ‘Work with TCP/IP host table entries’ and add the IP address and name of the SQL server.
ps, if you DO have a DNS server on your network, you should add the SQL server to that.
