AS400 JDBC drivers

[Former Member]

Hi SDNers,

I need to connect to AS400 DB2 using JDBC adapters. I tried to download IBM Toolbox drivers for the same from the <a href="http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2007-08-23+08%3A09%3A57.490556R&S_TACT=104CBW71&S_CMP=">IBM website</a>. But this requires a IBM user id, which I dont have. If any one of you have this driver, pls send it across to my id. You can find my mail id in Business card.

Thank you.

Regards,

Jai Shankar

[Former Member · Accepted solution]

Hi,

I sent you file. Please chk n confirm.

You can also create IBM id & it will take 1 day atleast to get activated & then you can download it from IBM site.

Regards

Sushil

[Former Member · Accepted solution]

Hi Sushil,

Many thanks for the driver. One last question, do I have to do any config in AS400 for using the JDBC drivers?

Regards,

Jai Shankar

[Former Member · Accepted solution]

No, I havnt done anything in AS400 for same.

Authorisation only should be sufficient to access data.

Regards

Sushil

[Former Member]

Hi jai

There are two types of DB2 JDBC Drivers are avialble.

1.The "Native" JDBC driver.

Driver:com.ibm.db2.jdbc.app.DB2Driver

Sub protocol:db2

Ex.jdbc:db2:localhost/COLLECTIONNAME

2.The "Toolbox" JDBC driver.

Driver:com.ibm.as400.access.AS400JDBCDriver

Sub protocol:as400

Ex.jdbc:as400://MACHINENAME/COLLECTIONNAME

So can you try with the Native JDBC Driver and protocol.

refer this may be helpful

http://www.wmusers.com/forum/archive/index.php/f-102.html

You can find a list of JDBC drivers here:

http://developers.sun.com/product/jdbc/drivers

Check out the drivertool utility in this zip.

While using the AS/400 Toolbox for java, instead of AS/400 DevKit4Java, you will find this IBM page very useful.

http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/info/java/rzahh/jdbc.htm

Also have a look at: http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzahh/javadoc/JDBCProperties.html

refer this Blog also

/people/sap.user72/blog/2005/10/04/extracting-data-from-an-as400-with-multimember-tables-using-xi

For connection details- this thread discussion will help u -

XI Connectivity with AS400 and OS390

Thanks !!