Re: iSeries programs to update MS SQL Tables

Hello Jody,

If you are open to commercial options our RPG2SQL Integrator software could
be just what you are looking for.

RPG2SQL allows RPG programs to read or write any ADO/ODBC data source thus
allowing you to talk to SQL Server, MySQL, Oracle or pretty much any
ADO/ODBC-enabled database.

The product also supports reading and writing to MS Excel spreadsheets with
the RPG2Excel functions.

With the included sample programs you'll be reading and writing SQL data
within minutes of installation.

For more information check out our web site and you can download a FREE
30-day demo or feel free to contact me directly for further discussion.

Regards,
Richard Schoen
RJS Software Systems Inc.
"Providing Your....iNFORMATION NOW!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT


"news.gt.ca" <jws@xxxxxxxxxxxxxxx> wrote in message
news:e2t5ah$i2n$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I need the ability to write RPGLE apps and use iSeries SQL to read and
update tables on a Microsoft SQL server. (Possibly MySQL in the future.)
I have a fair amount of experience with OS400 and RPGLE. I guess I am
looking for something similar to and ODBC driver for the iSeries(Don't
know
if there is such a thing). I can write the app in VB using windows ODBC to
work with the iSeries, but I am the only developer here that is familiar
with VB. I would like to keep the code native to the iSeries if possible.

Any suggestions on approach would be greatly appreciated.

Thanks

Jody




.

Relevant Pages

  • Re: Question for the MVPs
    ... > project* that I've had clunking around in my head and I just figured ... Even IBM is finally admitting that the ISeries ... I've been doing Access front ends to some IBM iron for several years now and a ... four figure xeon SQL Server will absolutely blow its doors off. ...
    (microsoft.public.access.modulesdaovba)
  • Re: iSeries programs to update MS SQL Tables
    ... RJS Software looks like a viable option has well, ... are dazzeled with Microsoft Dynamics, sharepoint,business portal and excel ... This seems to have caused a delay in purchasing iSeries ... update tables on a Microsoft SQL server. ...
    (comp.sys.ibm.as400.misc)
  • Client "Host not found"
    ... I am trying to use JDBC to access data on an MS SQL Server from an IBM ... iSeries server. ... I compiled and ran a sample Java ... ERROR CODE: 0 ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: iSeries programs to update MS SQL Tables
    ... "native" IO to SQL Server tables from RPG. ... I need the ability to write RPGLE apps and use iSeries SQL to read and ... looking for something similar to and ODBC driver for the iSeries(Don't ... work with the iSeries, but I am the only developer here that is familiar ...
    (comp.sys.ibm.as400.misc)