Update Query?

[trungx]

I want to update column NAME of table ExamDB using code below, but: No suitable drivererror appears. Help!
=================

Database database1 = new Database();
QueryDataSet queryDataSet1 = new QueryDataSet();
try
{
Connection connection=DriverManager.getConnection("jdbcdbc:ExamDB", "",""
Statement statement=connection.createStatement();

statement.executeUpdate("UPDATE ExamDB.Table1 SET NAME = 'name' "

statement.close() ;
connection.close() ;
} catch (Exception ex){

System.out.println(ex);

}

 

[shyamkumar]

Hey
use this first before opening up the connection
i.e before get connection.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"
Then try
Shyam

Shyam

 

[trungx]

Oh! I forgot it!. Thanks very much Shyamkumar