DB2 Connection Setting..?

[Former Member]

Hi All,

I have used below setting for JDBC adapter....

JDBC Driver--->com.ibm.as400.access.AS400JDBCDataSource

Connection -

---

>jdbc:as400://217.28.190.114:1433;databaseName=GRPDTA

but i am getting this error...

Error during database connection to the database URL 'jdbc:as400://217.28.190.114:1433;databaseName=GRPDTA' using the JDBC driver 'com.ibm.as400.access.AS400JDBCDataSource': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:as400://217.28.190.114:1433;databaseName=GRPDTA': SAPClassNotFoundException: com.ibm.as400.access.AS400JDBCDataSource'

10/25/07 2:31:00 PM Processing started

what does this error means?

[Former Member]

Hi

Download universal driver for DB2,the jar file

http://www-128.ibm.com/developerworks/db2/library/techarticle/0203zikopoulos/0203zikopoulos.html

also have a look at the following to install these driver in XI

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

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

Connection :jdbc:as400://ServerName/databaseName

Thanks

[agasthuri_doss]

Hi,

1)Check whether you have deployed all the required Driver

2)Check the connection Parameters is right and also check that user ID and Password also we have to mention in the Parameter.

Regards

Agasthuri Doss

[Former Member]

Hi,

Check JDBC Drivers have been installed or not.

Check this links for drivers.

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

To install oracle drive in XI server, just check these links,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

http://msdn2.microsoft.com/en-us/library/ms177523.aspx

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=jdbc%20with%20multiple%20tables&cat=sdn_all

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

JDBC -http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

Regards,

Phani

Reward Points if Helpful

[Former Member]

Hi Ranjeet,

Check first if you have installed JDBC drivers on XI.

Nilesh