ODBC Data Source

Home Useful Info 1 Pre-Test1 Project + Milestone 1 Sample Use Cases How to Install DukeBookStore Pre-Test2 JSDK Milestone 2 Final Milestone Announcements Running JSDK at Home Project Team Evaluation Project Information Form ODBC Data Source

 

Setting Up an Access DataStore for your JDBC-ODBC Java Programs

  1. Double click on the Start | Setting | Control Panel | 32 Bit ODBC icon. Will see the ODBC Data Source Administrator screen.
  2. On the User DSN tab, click Add.
  3. Will see the Create New Data Source screen.
  4. Select Microsoft Access Driver and click Finish.
  5. Will see the ODBC Microsoft Access Setup screen. Under Data Source Name, enter the name that you want to have associated with the database, e.g., eCommerceDB. (This is the same name that you need to use when specifying the DB URL in your program, e.g., jdbc:odbc:eCommerceDB.)
  6. Click on the Select … button to select the file that is to be associated with your database (e.g., c:\somedir\myDb.mdb). This assumes that you have already created an Access database using Access earlier.
  7. Click OK
  8. Click OK again to leave the ODBC Data Source Administrator screen.