Re: Iseries/AS400 access to external databases



If you're open to commercial options, check out our RPG2SQL Integrator
software.

You can read/write data from any RPG program to SQL Server, Oracle, MySQL or
any other database accessible via ODBC/ADO.

Takes about 15 minutes to install and get started.

For more information check out our web site or feel free to contact me
directly to discuss.

Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT

<dwise@xxxxxxxx> wrote in message
news:1178905946.291453.84290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
We have most of our data on Iseries and have that data accessible to
external clients via ODBC, service programs, etc.

However in some cases we have external data that is being used and
maintained either in Microsoft Access Databases, MS-SQL servers, (I
guess Oracle and MySQL might be other sources but not in our case).

Is there any way to set up the Iseries so that it can treat that
(external windows database) data as though it were local, in the same
way that an external client can treat the AS400/Iseries data as though
it were local.

I have not seen the description or setup information for such a
connection. It is sort of the opposite of what we normally need to
do, but such an ability could prove very useful to us.

Maybe I am missing something obvious.



.



Relevant Pages

  • RE: Windows Services and SQL Server
    ... There are managed providers for Oracle, MySQL and other RDBMS's. ... SqlClient class with a regular SQL Server login? ... I'm using ODBC Drivers ...
    (microsoft.public.dotnet.languages.csharp)
  • Parameterized queries to different data providers
    ... I would like to build my app so it can connect to SQL Server, Oracle ... or mySQL and query data. ... Data queries should be parameterized to reduce impact of SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle - MySQL decision
    ... I'm suprised you've not considered Microsoft SQL Server 2005 Express edition ... I'd choose Oracle since I have used it since version 7 and I ... > MySQL 5.0 on the other hand is a close contender. ... Many potential customers have flexible site ...
    (comp.databases)
  • Re: alternative to DTS
    ... Alternatively FastReader can write data ... I used to use DTS for transferring data between Informix and SQL Server ... I now need to replicate data between Oracle ... and MySQL and need a similar tool. ...
    (microsoft.public.sqlserver.dts)