JDBC Sender Adapter for AS/400 DB2 (V5R1) Error

84 Views

Hi,

I'm trying to create a connection to an DB2 database on an AS/400 (V5R1) server. First does anyone know what JDBC driver I should use for this... I am trying to use the DB2 Universal type 4 JDBC driver... But have a suspicion I should be using the Legacy type 2 which I'm trying to track down with the client. If anyone can give me details as to where exactly I can find this driver it would be very useful???

Currently my settings are as follows:

JDBC Driver: com.ibm.db2.jcc.DB2Driver

Connection: jdbc:db2://10.101.10.9:446/PROTST01

I have verified my user is correct etc... I get the following response in the RWB.

- 2006-01-13 10:54:40 GMT: Error: Accessing database connection 'jdbc:db2://10.101.10.9:446/PROTST01' failed: com.ibm.db2.jcc.b.SqlException: Connection authorization failure occurred. Reason: local security service non-retryable error.

Can this error be resolved or should I concentrate on installing the legacy type 2 driver and trying that???

Thanks in advance,

Pete