Results 1 to 1 of 1
Thread: error message
- 01-13-2011, 02:20 PM #1
Member
- Join Date
- Jan 2011
- Posts
- 1
- Rep Power
- 0
error message
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);
}
Similar Threads
-
Error Message ..
By Hamodi18 in forum New To JavaReplies: 15Last Post: 07-11-2010, 04:31 AM -
error message assistance
By Sean_J in forum New To JavaReplies: 12Last Post: 03-17-2010, 03:27 AM -
Help with servlet error message
By ricky_40 in forum New To JavaReplies: 1Last Post: 03-08-2010, 07:01 AM -
Error Message????
By Cubba27 in forum New To JavaReplies: 11Last Post: 11-21-2009, 03:46 PM -
error message on jsp
By sandor in forum Web FrameworksReplies: 1Last Post: 04-11-2007, 03:10 AM
Bookmarks