Re: iSeries programs to update MS SQL Tables

I believe RJS Software will sell you a application that allows you to do
"native" IO to SQL Server tables from RPG.

Sam

"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
    ... If you are open to commercial options our RPG2SQL Integrator software could ... RPG2SQL allows RPG programs to read or write any ADO/ODBC data source thus ... update tables on a Microsoft SQL server. ... work with the iSeries, but I am the only developer here that is familiar ...
    (comp.sys.ibm.as400.misc)
  • 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: SQL Losing Data
    ... the other problem wasn't a SQL Server thing. ... And I would argue that it was an ODBC driver issue, solely, not even Access. ... sidebar shows a pencil, indicating that edits are being performed. ... I've tried using Profiler in the past and found it a bit unwieldy. ...
    (microsoft.public.sqlserver.odbc)