Driver Error : java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no defau

Question

Driver Error : java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ,
I'm getting this error message while i ty to run code in MSAccess with jsp as fronend

Answer 1

You have to specify the dsn name, I think if you have done the dsn
it will not be in the right way, check once again, using the following guidelines

Goto Control Panel
Start > Settings > Control Panel
Double Click the Administrative Tools
Double Click the Data Sources (ODBC)
a window will appear with title as
ODBC Data Source Administrator
Click on the System DSN Tab at the top
then Click on the Add Button
Choose Driver from the list of drivers
Here in your case it is
Microsoft Access Driver (*.mdb)
Then Click Finish
A window appears asking Data Source Name (Type here the data source name)
Then click the select button
Browse through the folders to the mdb file choose the file by clicking it and then press ok
Your dsn is ready now.
You have to specify it on the programming code.

Connection cn=DriverManager.getConnection("jdbc:odbc:");

you contact me for more clarification

My No: 9995403653
email: [e-mail]

good luck.