Re: ODBC from IFS -- MIDRANGE-L

Thanks for the links.  I actually think that I have
been there before, but I'll re-look them over.  

I think that my main problem was that the Databases
that are addressed in these articles are the more
robust ones such as Oracle, Sybase,  SQL Server, etc. 
Dbase III/IV & MS Access are 3 databases that are used
by several of our systems that I haven't found a
solution for.

DRDA has come up many times, but I have yet to try to
completely understand it (another technology to try
and learn on my own <smile>)and I also believe that it
takes cooperation with the Database provider which
I've looked at in the case with Microsoft.  But I
don't believe they support it or at least not anymore.

Actually a product by RJS, rpg2sql could be a
possibility (RPG) that I haven't checked into yet. 
But this means that I will have to request yet another
purchase to enable the iSeries to do the job that can
be done by a PC on our server farm.

Thanks again,
Don McIntyre

--- Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
> Don
> 
> Here is an article that covers this topic. Might be
> helpful:
> 
>
<http://www-919.ibm.com/developer/db2/documents/data_acc/index.html>
> 
> called "Heterogeneous data access for iSeries
> applications". Covers the 
> Java approach, and others.
> 
> This came from the iSeries DB2 page - tips - 
>
<http://www-1.ibm.com/servers/eserver/iseries/db2/db2tips.htm>
> 
> Vern
> 
> At 11:51 AM 7/9/2003 -0700, you wrote:
> >My particular problem was wanting to access files
> >residing on Windows PC's using Java (or even RPG)
> >applications that reside on the iSeries.
> >ODBC can be used for other databases, i.e. dbase
> >III/IV, MS Access, etc.
> >
> >These databases exist because different departments
> at
> >our organization has aquired applications (for one
> >reason or another) that run on PC's and utilize
> these
> >databases.  I would like be able to run
> applications
> >strictly off of our Enterprise System (iSeries) to
> >access & manipulate these heterogeneous databases.
> >
> >I currently have been writing Java programs that
> >reside on the PC's and I will kick them off from
> our
> >iSeries (i.e. runrmtcmd, or PC Scheduled jobs,
> etc).
> >
> >Not being able to do this from the iSeries is
> killing
> >my argument with management to expand our iSeries'
> &
> >NOT our server farm.  But when we are able to
> access
> >any application's (including iSeries) database from
> an
> >application residing on a PC, and not from an
> iSeries,
> >then my argument becomes moot.
> >
> >I have discussed this with people at IBM & others.
> >Joe Pluta at one time turned me onto the SQL 2000
> JDBC
> >type IV driver, which helps with the SQL 2000
> access,
> >but not the others.
> >
> >Don
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com