Re: Connect to Microsoft Access Database from AS400 using java

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