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.
Dig deeper on Web Development
Related Q&A from Jim Mason
Java to Excel with the AS400 may be attractive, but if you have complex VBA macros in Excel, the JDBCODBC bridge will not work well for you. A better...continue reading
There are a couple of options for accessing AS/400 data, from the old way using Client Access ODBC drivers, to Java, to a new application from Groovy.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.