>I am still looking for the VFP wizzard who can help me with code to call a program from my VFP app to the AS/400 using the Client Access toolkit. Any takers?
>
>God Bless,
>S. Dyke

Well I'm definitely NOT a wizard when it comes to anything on the AS400 -but- I am just starting a project that will require me to fire some RPG's up on that monster from VFP. Maybe we can collaborate? Here's where I sit. We are considering two approaches. My first preference is to call RPG's as stored procedures through ADO. First problem is that Client Access's current OLE-DB provider does not allow you to pass the UserID / password. Manual login is required so this makes it totally useless in a middle tier situation. I can move this piece to the front and have the user login as a temporary work around. IBM is supposed to add the login capability on the next release. They have even added the docs to their OLE-DB specs. My second problem is that I'm getting the infamous C….5 when trying to return a recordset via ADO through the OLE-DB provider. This might just be a configuration problem on my machine so I'll be trying to get this to work over the next couple of days.

Our second option we have already successfully implemented. Calling RPG's from Java using IBM's VisualAge 2.0 Java and the AS400 Java toolbox. This has been done for some web server interfaces. I will be looking at putting the class into a COM wrapper to be able to call from VFP. The main issue I have here are some compatibility problems with the Java virtual machine runtimes. Seems the toolbox classes likes the IBM runtime, wonder why?