RE: Connect to Microsoft Access Database from AS400 using java

There is an article in the October issue of iSeries NEWS that shows you how
to pass an SQL statement from an RPG program to an SQL server via a Java
program that uses JDBC to connect to the SQL server.

You can download all the source, but you need a membership to the iSeries
Network.

HTH,

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: Sethi, Ramesh (US) [mailto:Ramesh.Sethi@xxxxxxxxxxxxxxxxxxx]
> Sent: Tuesday, November 16, 2004 1:11 PM
> To: Java Programming on and around the iSeries /AS400
> Subject: RE: Connect to Microsoft Access Database from AS400 
> using java
> 
> 
> Hi Beppe and all,
> 
> I am desperately looking for a way to connect to SQL Server database
> from As400 using Java.
> 
> Any inputs on how it can be accomplished or what jar file I 
> need to use,
> will be of great help!
> 
> Thanks.
> 
> --------------------------------------------------------------
> ----------
> Ramesh Sethi 
> 
> 
> -----Original Message-----
> From: java400-l-bounces+ramesh.sethi=poloralphlauren.com@xxxxxxxxxxxx
> [mailto:java400-l-bounces+ramesh.sethi=poloralphlauren.com@mid
> range.com]
> On Behalf Of Beppe Costagliola
> Sent: Tuesday, November 16, 2004 4:10 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: Re: Connect to Microsoft Access Database from AS400 
> using java
> 
> I think there are some FREE drivers for SQLserver but none for Access.
> If you know that one exists, can you please tell us ?
> Thanks.
> Beppe.
> 
> ----- Original Message ----- 
> From: "Franco Biaggi" <fbiaggi@xxxxxxxxxx>
> To: "Java Programming on and around the iSeries / AS400"
> <java400-l@xxxxxxxxxxxx>
> Sent: Monday, November 15, 2004 9:11 PM
> Subject: Re: Connect to Microsoft Access Database from AS400 
> using java
> 
> 
> > Ashish Kulkarni wrote:
> >
> > >Hi
> > >is it possible to read or update data in Microsoft
> > >access database from a java programming running on
> > >AS400,
> > >If i have to connect to Access database from windows i
> > >create a system DSN and then use it, is it possible to
> > >do some thing like that from AS400
> > >What can i do if i have to read or update data in
> > >Microsoft Access database.
> > >
> > >Ashish
> > >
> > >__________________________________________________
> > >Do You Yahoo!?
> > >Tired of spam?  Yahoo! Mail has the best spam protection around
> > >http://mail.yahoo.com
> > >--
> > >This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L) mailing list
> > >To post a message email: JAVA400-L@xxxxxxxxxxxx
> > >To subscribe, unsubscribe, or change list options,
> > >visit: http://lists.midrange.com/mailman/listinfo/java400-l
> > >or email: JAVA400-L-request@xxxxxxxxxxxx
> > >Before posting, please take a moment to review the archives
> > >at http://archive.midrange.com/java400-l.
> > >
> > >
> > >
> > >
> > >
> > Yes,
> > werx simple, usee the JDBC_ODBC driver
> >
> > -- 
> >
> --------------------------------------------------------------
> ----------
> --
> ---
> > *** This messages was scanned for malicious contents ***
> >
> --------------------------------------------------------------
> ----------
> --
> ---
> > Franco Biaggi
> > CH-6807 Taverne
> >
> >
> > --
> > This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L)
> mailing list
> > To post a message email: JAVA400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/java400-l
> > or email: JAVA400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/java400-l.
> >
> 
> --
> This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
> 
> 
> 
> 
> --
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>