i use ucanaccess and get the error(error in connection)i also add the .jar files in p

[amirhan]

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
String s1,s2;
s1=u.getText();
s2=p.getText();
try{
Class.forName("net.ucanaccess.jdbc.UcanaccessDrive r");
Connection con=DriverManager.getConnection("jdbc:ucanaccess://C://Users//awagold//Documents//test123.accdb");
Statement st=con.createStatement();
int a=st.executeUpdate("insert into test123 values('"+u+"','"+p+"')");
if(a==1){
res.setText("Inserted");

}else{
res.setText("not Inserted");
}
}
catch(Exception e){
System.out.println("Error in Connection");
}
}

[amirhan]

Error is Error in Connection

[chaarmann]

you have given no password in your connection string. Also, please list the complete details of the connection error description here. It will be meaningless for you, but not for the expert.

It also may be better for you if you list this eror in the database forum.

[amirhan]

Thanks alot but today i solve this problem...!!!

[chaarmann]

Nice to hear! Can you please let us know how?
Your post will be read by hundreds of users who wants to know how such a problem is solved. If you are telling them, then you are really thankful. One hand washes the other....