Re: Unable to connect using JDBCR4... -- RPG400-L

Did you examine if there is any info in the joblog?

You can try if there is a physical connection from your i to the server.

From qshell try to reach that port with curl.

This will fail because of the protocol, but will at least return some http
content if the port is open:

curl mg01dbs03 1433

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""
http://www.w3.org/TR/html4/strict.dtd";> etc.
curl: (7) Failed to connect to IP number 1

Best regards,
-Arco

Op donderdag 4 mei 2017 heeft Robert Rogerson <rrogerson@xxxxxxxxxxx> het
volgende geschreven:

Our network folks can't see any reason why TELNET can access the server
but JDBCR4 can not.

Does anyone know if there's a log file (or can one be turned on) that
might shed some light on the issue?

Thanks,

Rob

On 5/3/2017 2:25 PM, Michael Ryan wrote:

But is the firewall open for port 1433? Check with your network folks.

On Wed, May 3, 2017 at 2:22 PM, Robert Rogerson <rrogerson@xxxxxxxxxxx>
wrote:

I am using port 1433

JDBC_setProp(prop: 'PORTNUMBER' : '1433');

Rob

On 5/3/2017 2:18 PM, Arco Simonse wrote:

This sounds like a firewall / accesslist issue. JDBC connects to port

1433
of the SQL server.

Best regards,
-Arco

Op woensdag 3 mei 2017 heeft Robert Rogerson <rrogerson@xxxxxxxxxxx>
het
volgende geschreven:

I'm hoping someone can help.

We're attempting to access an SQL Server database on an outside
company's
server.

For initial testing I was (and am still able) connecting to and
executing
SQL statements on one of our company's servers. But when I try to
connect
to outside company's server the connection fails.

In debug I was able to step until

conn = CallConnectMethod(JNIENV_P: drv: mid: str: prop); // In
procedure Driver_ConnProp

drv, mid, str and prop all have values but when this statement executes
it
returns 0.

I have been able to successfully ping the outside company's server.

I have been able to TELNET to the outside company's server.

A network person on the outside company's end saw traffic for both the
ping and the TELNET but they didn't see any traffic when I was
attempting
the connection using my JDBCR4 program.

I'm guessing that our system may be stopping the connection from going
out
when using JDBC but allows it from ping and TELNET. But I have very
limited networking knowledge.

Does anyone have any suggestions as to what the problem may be?

Thanks,

Rob

--
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

--
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