April 17, 2009 at 11:03 AM
As you have told , it seems that u haven't created the DSN file in proper manner. It's throwing exception due to incorrect DSN as your code is working here perfectly, there is no problem in this code. Please make sure about DSN connection. You can use the following steps for creating DSN connection:
1. Open Data Sources (Start->Control Panel->Administrative Tool->Data Sources(ODBC)
2. Open User DSN tab
3. Add a user DSN
4. Select Microsoft Access Driver(*.mdb)
5. Select database name and Create the DSN name (e.g emp)
6. Click "Ok" and then try the JSP.
I hope that this will help you in solving your problem.