Showing posts with label Connect JSP with Microsoft Access Database. Show all posts
Showing posts with label Connect JSP with Microsoft Access Database. Show all posts

Steps to Connect JSP with Microsoft Access Database


Step 1:

Run                 C:\Windows\System32\odbcad32.exe

OR

                        Navigate to "C:\Windows\SysWOW64"

Find "odbcad32.exe", right click on it and do "Run as Administrator"

Step 2:

Click on System DSN

Step 3:

Add
Microsoft Access Driver (*.mdb, *.accdb)

Step 4:

Write Data Source Name

Example: DriverManager.getConnection("jdbc:odbc:bank","","");
In this DSN is Bank

Step 5:

Database
Select and give Path
Then Click ok

Step 6:

If database not configured then reopen ODBC and configure database path again.


Note: No need of JDBC Driver/ODBC-JDBC Bridge is required.