Accessing MS SQL Server database from the iSeries

0 pts.
Tags:
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
ASKED: November 2, 2007  5:26 PM
UPDATED: February 20, 2010  9:00 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

===========================================================

<i>Accessing MS SQL Server database from the iSeries</i>

Once you get the TCP/IP configuration correct, the next thing you’ll need is a driver from Microsoft to actually access the MS SQL Server database. Good luck getting Microsoft to give you one.

You might have success with Java and a JDBC driver (from Microsoft). The database vendor is responsible for making drivers available. They know the necessary protocols.

Tom

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • djac
    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.
    900 pointsBadges:
    report
  • djac
    ps, if you DO have a DNS server on your network, you should add the SQL server to that.
    900 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following