Q

Working with ODBC and JDBC

How can I create an ODBC connection to the iSeries, and create a statement with Java to insert to a file on the database?
ODBC is standard -- you use ODBC to the iSeries in the same way you use ODBC to connect to Oracle. The iSeries Navigator contains a good ODBC driver (it is also free).

JDBC is standard -- you use insert to iSeries from Java exactly as you would insert to Oracle. The Java Toolbox contains a solid JDBC driver for iSeries (it is also free).

Click here for sample code.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Visit the ITKnowledge Exchange and get answers to your connectivity questions fast.

The Best Web Links: Tips, tutorials and more.

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

This was last published in May 2005

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close