Connection to DB2

[former_member614185]

Hi all,

I need to connect to DB2 Database using the JDBC Adapter. I have deployed the following jar files in my XI system,

db2jcc.jar

db2jcc_license_c.jar

But still im getting the following error,

Error during database connection to the database URL 'jdbc:db2://10.236.70.114:50000/EPEDIGRE' using the JDBC driver 'com.ibm.db2.jcc.DB2Driver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:db2://10.236.70.114:50000/EPEDIGRE': com.ibm.db2.jcc.a.SqlException: [ibm][db2][jcc][1078][11539] Expired JDBC driver. IBM DB2 JDBC Universal Driver Architecture 3.1.5 Test Build expired on 12/30/06 12:00 AM.'

please help me.

[Former Member · Accepted solution]

Try to downlod new license file from IBM site & deploy it again as it seems licensing issue.

Regards

sushil

[former_member614185 · Accepted solution]

Hi sunil,

if you have that link send to me

[Former Member · Accepted solution]

Try this link

http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc...

I used it for AS400 driver but I guess toolbox should have your driver files also.

Regards

Sushil

[former_member614185 · Accepted solution]

I checked that link, but couldnt find file location

[Former Member · Accepted solution]

From where u got db2jcc.jar & db2jcc_license_c.jar . Try at same location.

Regards

Sushil

[former_member614185]

problem solved

[Former Member]

hi

give the

JDBC DRIVER = oracle.jdbc.driver.OracleDriver

connection = jdbc:oracle:thin:@<ip address>:<port no of oracle db>:dbname

check u r user name & pasword

check u query sql statement & update sql statement