|
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 >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.