R: Accessing MS Access from Java on iSeries

I'm sorry for misundestanding!
I've tried it only accessing on SQLServer DB!
on MS Access you should try reading documentation on
http://jtds.sourceforge.net/



Regards!

Vincenzo Amoruso
Co-Founder & Ceo

System Project s.r.l.
Via De Giosa, 39
70031 Andria(BA) Italy

Tel. +39(0)883 566 648

mail : info@xxxxxxxxxxxxxxxxx

http://www.system-project.it

Projects References :

http://www.system-project.it/IT/novita.html

http://www.netjug.com

-----Messaggio originale-----
Da: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx]Per conto di Joe Sam Shirah
Inviato: martedi 31 gennaio 2006 13.52
A: Java Programming on and around the iSeries / AS400
Oggetto: Re: Accessing MS Access from Java on iSeries



    I'd be very surprised to see Vincenzo's response work.  I don't want to
put words in his mouth, but I suspect he thought you meant "accessing an MS
database", that is, SQL Server.  There is no separate DB engine with Access,
so the driver has to include or emulate Jet ( is it still called that? ) to
work with Access files.

    Typically, the JDBC-ODBC bridge, which Sun has always noted as
"experimental" - meaning buggy, not production quality, is used in
combination with an ODBC driver.  Notice that extra steps must be taken to
work with Access files on a remote machine, from an AS/400 or anything else,
because Access doesn't provide anything to talk to over the network, in and
of itself.  Access can talk to SQL Server, and Java can talk to SQL Server,
which is probably the best solution overall, but doesn't help in the normal
case.

    There are some commercial JDBC drivers that emulate the Jet engine.
I've never used them due to Access' non-standard SQL and general
unreliability in a production environment.  Google on "MS Access Java" for
more information.


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400


----- Original Message -----
From: "Vincenzo Amoruso" <vincenzo.amoruso@xxxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, January 31, 2006 6:19 AM
Subject: R: Accessing MS Access from Java on iSeries


> Try at this url for accessing with type 4 db driver :
>
> http://jtds.sourceforge.net/
>
>
> Here a sample including jtds-1.2.jar in iSeries classpath
>
> <sample>
> import java.sql.DriverManager;
> import java.sql.Connection;
> import java.sql.SQLException;
>
> public class TrySqlServer {
> public static void main(String[] args)
>     {
> Connection cn = null;
> try {
> try {
> Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
> System.out.println("OK Driver");
> } catch (ClassNotFoundException e) {
> e.printStackTrace();
> }
> cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://ip:1433/myDB",
> "sa" , "" );
> System.out.println("Connection OK");
> } catch (SQLException e) {
> e.printStackTrace();
> }
>
>
>
>     }
> }
> </sample>
>
> Hope this helps!
>
> Regards
>
> Vincenzo Amoruso
> Co-Founder & Ceo
>
> System Project s.r.l.
> Via De Giosa, 39
> 70031 Andria(BA) Italy
>
> Tel. +39(0)883 566 648
>
> mail : info@xxxxxxxxxxxxxxxxx
>
> http://www.system-project.it
>
> Projects References :
>
> http://www.system-project.it/IT/novita.html
>
> http://www.netjug.com
>
> -----Messaggio originale-----
> Da: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx]Per conto di Anand, Rajesh
> Inviato: martedi 31 gennaio 2006 11.44
> A: java400-l@xxxxxxxxxxxx
> Oggetto: Accessing MS Access from Java on iSeries
>
>
> 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
>

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