This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

Creating an MS Acess Database connection

Posted by Anil on November 21, 2000 at 4:56 PM

Add that entry of the Access database in the User DSN (Control Panel -> ODBC Data Sources -> select Access Driver). Once that is done u can use that datasource in ur java code using the sun provided jdbc-odbc drivers.
given below is the code:
String url = "jdbc:odbc:Books"; //books is the name of DSN
String username = "anonymous";
String password = "guest";

// Load the driver to allow connection to the database
try {
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
connection = DriverManager.getConnection(
url, username, password );
}
catch ( ClassNotFoundException cnfex ) {
System.err.println(
"Failed to load JDBC/ODBC driver." );
cnfex.printStackTrace();
System.exit( 1 ); // terminate program
}
catch ( SQLException sqlex ) {
System.err.println( "Unable to connect" );
sqlex.printStackTrace();
}

To decide on which database to use for a site is purely a business decision.. personally i feel that Oracle is better given its reliability and stability.

• can we use query in ms acess shruti_rohatgi April 10, 2001 at 12:55 PM (0)
• how a pure jdbc connection for ms-access? mahesh February 26, 2001 at 12:59 AM (2)
  • about how to acess databse ananth May 29, 2001 at 2:27 AM (0)
  • jdbc arj April 03, 2001 at 5:37 AM (0)
• ms acess help sohail yousuf January 02, 2001 at 8:22 AM (0)