RE: Connect to Microsoft Access Database from AS400 using java

[CWilt@xxxxxxxxxxxx]

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.
>