Re: Delphi with a AS/400 database

["L. S. Russell" <leslier@xxxxxxxxxx>]

Hi Pascal,

Search for a product called Activit 400.  This is a set of components
for Delphi 3 and higher that allow your applications to access the 400's
database without using ODBC.  
If you are not interested in paying for these components, then you could
use the ODBC drivers that comes with CA.  Just start the Database
desktop and set up a database using the ODBC drivers.   It has been a
very long time since I went this route, I am sure there is some set up
required on the CA side.  But once you get your connection going (except
for the slowness of the ODBC) it works pretty well.  

I have used Activit 400 and it is very cool product, just can't remember
who makes it.  You can download a demo version of the components. 
  

> Pascal Bellerose wrote:
> 
> Hi there,
>     Some of you may recongnize me I was at Progisys inc. a few weeks
> ago.
> I would like to take some outputs from a PC Delphi application (I
> don't know the version of delphi yet), and insert them into an AS/400
> database.  Now it's the first time I'm going to do this and I guess it
> won't be the last.
>     How could this be done? I've thought of having the Delphi
> application calling an RPG program that would receive the data through
> some parameters.  But then I started wonder if there was a limit for
> the lenght of the parameters passed to an RPG program.  And finally I
> wondered if I was at least able to pass parameters to a RPG program
> through a Delphi program.  And is there data conversion process to
> do?(ex :ASCII to EBCDIC).
> 
>     Anyway maybe I'm focusing on the wrong solution.
> 
> Anybody has an idea?
> 
> Thanks In advance!
> 
> 
> Pascal Bellerose
> Programmeur-Analyste
> Portbec inc.
>
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---