About Lesson
Connecting to Access Database using JDBC Type-1 Driver
To connect a Java application with Access database using JDBC-ODBC Bridge(type-1) Driver. You need to follow the following steps.
Note: In Java 8, the JDBC-ODBC Bridge has been removed. It is no longer supported.
Create DSN Name
- Go to control panel
- Go to Administrative tools
- Select Data Source(ODBC)
- Add new DSN name, select add
- Select Access driver from the list, click on finish
- Give a DSN name, click ok
NOTE: Here we are showing this example to create DSN in Window 7 os. For other operating system you need to do small changes.
Time for an Example!
We suppose that you have created a student table with sid and name column name in access database.