Connecting JSP page with MS Access :: JDBC ODBC Connectivity
H ello Guys .This post is all about Connecting JSP to MS Access database -> JDBC ODBC Connectivity. Honestly speaking after struggling upon a lot on jdbc connectivity , finally at the end of the day , I brought to you the step by step process to CREATE database and perform DDL and DML operations on that. So , Lets begin by creating a MS Access database. Go to Control Panel > Administrative Tools > ODBC DATABASE SOURCES. Now an ODBC Data Source Administrator window will open. Click on Add button . Now Select Driver do Microsoft Access(*mdb) from the Create New Database Source window that appears like the image shown on right and click Finish Button.. Now create your Database source name . You can give any name you want. THIS NAME IS CALLED YOUR DNS ( Database Sourcse Name ). Click on "Create " button. NOW THIS STEP IS Worth IMPORTANT. PEOPLE USUALLY GIVES C:\ DRIVE PATH ( the NTFS where windows is installed generally).. There's no pr