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





From: Robert Rogerson <rrogerson@xxxxxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 05/22/2017 10:21 AM
Subject: Re: JDBCR4 error Unknown server host name
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



I don't recall having to install the jtds driver on SQL Server.

Looking at my connection string I use to actual IP address rather that
the connection name. Perhaps try the actual IP address of VServer02.

Rob


On 5/22/2017 9:57 AM, gio.cot wrote:

Hi Rob



Thanks for your reply ..



".Also note, in the source for JDBCR4 if you scan for JDBC_Connect you

will

see comments that JDBC_Connect is actually just a wrapper for

JDBC_ConnProp.

I would recommend using JDBC_ConnProp as jdbc_Connect just calls
jdbc_ConnProp but my calling jdbc_ConnProp directly you are able to

populate

the connection properties."

I'm try to follow you suggestion .. sorry for my ignorance.. pheraps I

have

to check my Sql server !! I also have to install the jtds driver in the

Sql

server?

Thanks in advance



P.S. user and pass are Ok for access to sever and DB

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD