× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I agree. If a PING works for the hostname, it should work fine in JDBCR4. As I pointed out on Code400.com, the connection string doesn't look correct to me (assuming SQL Server is the target).




-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Monday, May 22, 2017 10:21 AM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: Re: JDBCR4 error Unknown server host name

If the ping works (which the OP noted) then I can't see how using the IP address will help. Here, where our network admin loves to change the IP addresses around on a whim hardcoding IP addresses instead of using DNS is a recipe for disaster. We have a data center move planned and I get to change all my IBM i, aix, etc addresses. Yee haw!

I would use the suggested analysis that others have provided. Hopefully it's not something like using a non variable length field and the spaces causing issues.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.