Ask the Expert

Build an application on a PC

We are using Microsoft Access to build an application on a PC. Can we write a program on the iSeries (RPGIV or Java) to directly access data on the MS Access database? At this time we are using FTP to transfer data we want direct access to on the MS Access database from the iSeries program. If ODBC or JBDC is the solution, then how can we set it up on iSeries?

No easy way to do this ...
You need an ODBC driver to get to Access. There ISN'T an ODBC driver for Microsoft on the iSeries. Your Java application can work EASILY IF you put it on a Microsoft OS. We do this all the time and it works well with that one restriction. Or use an automated FTP script from the iSeries to do a "get" on a network connected Windows system via URL.

This was first published in September 2002

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: