Re: Accessing MS Access from Java on iSeries

Never tried it and it isn't open source but you might want to try this JDBC
type 4 driver.  Does have a trial version.

http://www.hxtt.net/proddetail.jsp?product=access

Russ



                                                                           
             Pete Helgren                                                  
             <Pete@xxxxxxxxxx>                                             
             Sent by:                                                   To 
             java400-l-bounces         Java Programming on and around the  
             @midrange.com             iSeries / AS400                     
                                       <java400-l@xxxxxxxxxxxx>            
                                                                        cc 
             01/31/2006 10:23                                              
             AM                                                    Subject 
                                       Re: Accessing MS Access from Java   
                                       on iSeries                          
             Please respond to                                             
             Java Programming                                              
             on and around the                                             
              iSeries / AS400                                              
             <java400-l@midran                                             
                  ge.com>                                                  
                                                                           
                                                                           




Well, based on what I have heard out the ODBC-JDBC bridge, it probably
isn't something I'd immediately put into production.  Joe never got past
the .1 version level with it and it has languished with no further
activity since it was released.

I DID install and use it and it does work as designed. The example code
works right out of the box.  However, you probably want to look at all
the points of possible failure and see what you can do to improve them.

In short, I am not sure I'd put any .1 release of any open source
project into production, but it does do what your original post required.

Pete


Anand, Rajesh wrote:

>            Peter,
>
>            Is this reliable and production quality??
>
>            Have you used it??
>
>            regards,
>
>Rajesh Anand
>Email:Rajesh_anand@xxxxxx
>
>
>-----Original Message-----
>From: java400-l-bounces@xxxxxxxxxxxx
>[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
>Sent: 31 January 2006 15:46
>To: Java Programming on and around the iSeries / AS400
>Subject: Re: Accessing MS Access from Java on iSeries
>
>
>Joe Pluta posted an open source project called OS400Bridge about three
>years ago that did just that as I recall:
>
>http://sourceforge.net/projects/os400bridge/
>
>Pete Helgren
>
>Anand, Rajesh wrote:
>
>
>
>>Folks,
>>
>>           Have been through the archives but have not found anything
>>conclusive.
>>
>>           Does anyone have any idea how this can accomplished??
>>
>>           This is an old age problem where we need to feed data to MS
>>Access and we need to provide an automated solution from iSeries.
>>
>>           I know its has been debated in the past but want to know is,
if
>>there are any MS jar files available to use on iSeries using Java.
>>
>>           Thanks for your help in advance.
>>
>>
>>
>>Rajesh Anand
>>Email:Rajesh_anand@xxxxxx
>>--------------------------------------------------------
>>
>>If you are not an intended recipient of this e-mail, please notify the
>>
>>
>sender, delete it and do not read, act upon, print, disclose, copy,
>retain or redistribute it. Click here for important additional terms
>relating to this e-mail.     http://www.ml.com/email_terms/
>
>
>>--------------------------------------------------------
>>
>>
>>
>>
--
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.