Re: Accessing an Access database using JDBC

What you use to register the driver and access the database is dependant on
what JDBC driver you want to use.  It doesn't really have much to do with
Access itself.  For example, I have written programs to do things to Access
databases using the JDBC/ODBC bridge.  You register the driver and get a
connection with it like this:

         // Register the JDBC driver.
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

         // Get a connection to the database to do our work under.
         connection = DriverManager.getConnection("jdbc:odbc:project");

Project was the name of my ODBC data source for this, em, project.  That
was all there was to it.  Everything else
(that I did anyway) was just standard JDBC.

Of course, there are many other drivers out there that can access Access.
I have not played with any of them.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

                                                                              

 Edgar Allan Poe
                                                                              

The Tell-Tale Heart"




"Martyn Oswin" <MartynOswin@CompuServe.com> on 07/22/2000 08:11:37 AM

Please respond to JAVA400-L@midrange.com

To:   JAVA400-L@midrange.com
cc:
Subject:  Accessing an Access database using JDBC




Hello,

Does anybody have an example of a class that they have written that
manipulates data in an Access database using JDBC? In particular,
registering the driver and opening the connection.

Regards

Martyn Oswin

Business: 0115 9230140
Mobile   :  0378 833290
E_Mail   :  MartynOswin@CompuServe.Com


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---