Connecting to a Microsoft Access Database

 

1.)  ftp to www.seasite.niu.edu and download the database named testdb.mdb or create your own Access Database

2.)  Set up an ODBC datasource on your computer.

3.)  In your Java server program, the driver manager you want to load is:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

4.) In your Java server program, the database driver to load is:

conn = DriverManager.getConnection("jdbc:odbc:testdb");

Note that after protocol:subprotocol: you provide the name of the datasource you configured in step 2.