Re: Connect to Microsoft Access Database from AS400 using java

["Bruce Jin" <brucej@xxxxxxxxxxxxxxxxxxxx>]

You can goto microsoft.com and download their jdbc driver for sql server
database.  Their driver is in mssqlserver.jar, msbase.jar and msutil.jar.
Put all these in classpath on your as400.

----- Original Message ----- 
From: "Sethi, Ramesh (US)" <Ramesh.Sethi@xxxxxxxxxxxxxxxxxxx>
To: "Java Programming on and around the iSeries /AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, November 16, 2004 12:11 PM
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@xxxxxxxxxxxx]
> 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.
>
>