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



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.