Re: iSeries programs to update MS SQL Tables

Thanks everyone for the responses.
I will take a look at IBM's white paper.
RJS Software looks like a viable option has well, but it seems our executive
are dazzeled with Microsoft Dynamics, sharepoint,business portal and excel
OLAP cubes. This seems to have caused a delay in purchasing iSeries
Software.

Out of Scope, but does anybody think IBM will be re-hashing a pricing
strategy to keep the iSeries alive or will IBM's focus be more geared
towards Large Enterprises instead of SME. It's seems in our area, a lot of
the iSeries shops have either removed the iSeries or are currently removing
apps 1 by 1. Microsoft has become the must have for SME's in our area for
ERP software.

Thanks All

Jody

"Richard Schoen" <richard@xxxxxxxxxxxxxxx> wrote in message
news:IbV4g.6390$Bh.3547@xxxxxxxxxxxxxxxxxxxxxxxx
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: Tabellendarstellung von Linked Servern
    ... Wenn ich einen Linked Server, in meinem Fall auf eine IBM iSeries, ... erstelle und zwar egal ob mit OLE DB von IBM oder ODBC von Microsoft. ... Denn verknüpfe ich in Access97 eine iSeries Tabelle ... wenn man nun eine View erstellt und will Tabellen des Linked Servers ...
    (microsoft.public.de.sqlserver)
  • 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)
  • Tabellendarstellung von Linked Servern
    ... Denn verknüpfe ich in Access97 eine iSeries Tabelle mit ODBC, ... wenn man nun eine View erstellt und will Tabellen des Linked Servers ... Ich denke nicht das Microsoft in einem SQL Server 2005 etwas rausnimmt was ...
    (microsoft.public.de.sqlserver)
  • 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)