cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 Connection Error

Former Member
0 Kudos

Hi All,

I am getting following error while connecting to DB2 database.

=============================================

Error during database connection to the database URL 'jdbc:as400://217.28.190.114/GRPDTA' using the JDBC driver 'com.ibm.as400.access.AS400JDBCDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:as400://217.28.190.114/GRPDTA': SQLException: The application requester cannot establish the connection. (Connection timed out: connect)'

==========================================================

I have deployed the jt400.jar file on server.

My setting are :

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

Connection: jdbc:as400://217.28.190.114/GRPDTA

Any idea what could the reason?

Ranjeet Singh.

Accepted Solutions (0)

Answers (2)

Answers (2)

agasthuri_doss
Active Contributor
0 Kudos

Hi,

>>Cannot establish connection to URL 'jdbc:as400://217.28.190.114/GRPDTA': SQLException:

Check whether the DB2 application is up.

>>The application requester cannot establish the connection. (Connection timed out: connect)'

Check the connection parameters mentioned are right.

Regards

Agasthuri Doss

Former Member
0 Kudos

Hi All,

Please help with some answer?

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

try to connect to AS via ODBC.

Driver: sun.jdbc.odbc.JdbcOdbcDriver

Connection:jdbc:odbc:<AS400 base>

Usr:

pass:

also see this:

http://www.skillbuilders.com/Tutorials-V2/Java_JDBC_Overview/Java_JDBC_Overview.cfm

Hope it help

Rgds

PS:rewards point if useful

Former Member
0 Kudos

Hi Rodrigo,

what exactly should i put in place of :<AS400 base>

?

Ranjeet Singh.