deal with microsoft access data base file from RPG program or clp

0 pts.
Tags:
Application development
AS/400
CLP
DB2 Universal Database
RPGLE
hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy
ASKED: February 5, 2006  12:45 PM
UPDATED: November 28, 2009  3:37 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You only THINK you need to have your RPG program talk to a MS Access data base. What you really need to do is to move the MS Access data base onto your mainframe, and then have MS Access access it remotely. Sticking with the data base on MS Access is asking for trouble, including very slow performance, and even the occasional lost record.

Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
800-315-1174 (+1-949-552-1904)

=========================================================

Microsoft is the vendor for Access. Therefore, Microsoft is the supplier of all ODBC drivers for Access or the supplier of published protocols to allow you to code your own. Contact Microsoft and ask them how to obtain the ODBC driver. (Hint: Expect laughter in reply. You didn’t really think Microsoft would supply drivers for other competitive platforms for Access, did you?)

Tom

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • graybeard52
    I believe ProdataComputer has a product that will do what you want.
    3,115 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following