Re: Connect to Microsoft Access Database from AS400 using java

I agree with Patrick... I use JTDS for this. I have
successfully connected to MS SQL Server 6.5 through
SQL Server 2000 databases from the AS400 with this
driver. 
It performs very well.

Thanks,
Ivan Hurtado

--- Patrick L Archibald
<Patrick.Archibald@xxxxxxxxxxxxx> wrote:

> I use http://jtds.sourceforge.net/
> 
> Thanx, PLA
> 
> 
> 
> Sethi, Ramesh (US) wrote:
> 
> >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.
> >
> >
> >
> >  
> >
> --
> 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.
> 
> 



                
__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - Get yours free! 
http://my.yahoo.com