i have a question
i made a database using ms.access
and i want to update this database from JFrame form on netbeans
when i call the data use jTextfield1focuslost then i have an error message
there is the message :
java.sql.SQLException:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

and there is sorce code im using :

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newI nstance();
//String dsn = "mahasiswa.mdb";
String dbURL = "jdbc:odbc:Driver={Microsoft Access Driver"+"(*.mdb, *.accdb)};DBQ=D:\\LatihanJDBCAcces\\JDBC_ODBC_ACCE SS\\mahasiswa.mdb";
Connection konek = DriverManager.getConnection(dbURL);
Statement st = konek.createStatement(ResultSet.TYPE_SCROLL_SENSIT IVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = st.executeQuery("SELECT * FROM tabel_biodata WHERE NIM= '" + jTextField1.getText() + "'");
while (rs.next()) {
jTextField2.setText(rs.getString("NAMA"));
jTextArea1.setText(rs.getString("ALAMAT"));
}
} catch (Exception e) {
JOptionPane.showMessageDialog(null, "TIDAK BISA MELAKUKAN QUERY"+e);
}