Problem solve Get help with specific problems with your technologies, process and projects.

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 last published in September 2002

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.