Re: Connect to Microsoft Access Database from AS400 using java

["Bruce Jin" <brucej@xxxxxxxxxxxxxxxxxxxx>]

A JDBC-ODBC comes with JDK. Try this in your Java code:



Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");



I don't think it is network capable. This means you may only access MS
Access locally using this driver.





----- Original Message ----- 
From: "Beppe Costagliola" <beppecosta@xxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, November 16, 2004 3:09 AM
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.
>
>