Ask the Expert

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 first published in May 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: