Connection issue to AS400 system

[former_member335564]

Hi all,

Im trying to connect an AS400 DB2 system through JDBC adapter.

Used the following parameters :

JDBC Driver: com.ibm.as400.access.AS400JDBCDriver

URL: jdbc:as400://host IP address (also tried other combination:

jdbc:as400://host IP adresss/databasename)

We have deployed the required jt400 jar on the PI server.

My PI server is in different domain than the database server Im trying to connect.

We have opened up the ports on the Pi server for connecting to this external server.

But im getting the following error in runtime work bench :

"java.sql.SQLException: The application requester cannot establish the

connection. (Connection timed out: connect)

I tried connecting to an AS400 system in the same domain as the PI server and it works well.

What could be the issue? Am i missing some required configuration either in the PI server or in the AS400 system?

[former_member335564]

Hi,

We were able to resolve the issue..

The problem was with the Client's firewall settings.

After the client opened up the connection from their side,we were able to connect to the AS400 system through JDBC.

[former_member335564]

Hi,

We were able to resolve the issue..

The problem was with the Client's firewall settings.

After the client opened up the connection from their side,we were able to connect to the AS400 system through JDBC.

[former_member335564]

Hi,

We were able to resolve the issue..

The problem was with the Client's firewall settings.

After the client opened up the connection from their side,we were able to connect to the AS400 system through JDBC.

[agasthuri_doss]

Hey.

Adapter unable to recorginise the Jar file you have deployed, Did you mentioned the JAR file in Provider.xml file ?

Are you able to ping the DB2 server ?

Cheers

Agasthuri

[former_member335564]

Hi,

Ya Im able to ping the DB2 server.

What is the location of Provider.xml file?