JDBC connection

[kiwuji]

I am tryin to to setup an application to connect to MS Access without having to setup DSN from control panel every time that take the application to another machine.
this is the Driver code but it's not working ... Any Suggestion!!!
Thanks,
Kiwuji

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" //Driver
String URL = "jdbcdbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ= ." +
File.separatorChar + "Database" + File.separatorChar + "MP3Files.mdb";

 

[sedj]

errors ?
Do you ever use your URL to connect to the db ?
Do you register your Driver with the DriverManager ?

 

[kiwuji]

yes, I think something is wrong with the connection string. Here my configuration function

public void configJDBC() {

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" //Driver
String URL = "jdbcdbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ= ." +
File.separatorChar + "Database" + File.separatorChar + "MP3Files.mdb";
con = DriverManager.getConnection(URL);
stmt = con.createStatement();

}
catch (ClassNotFoundException cls) {
System.err.println("Class for JDBC is not found"
}
catch (SQLException sql) {
System.err.println("Error configuring jdbc"
}
}

 

[kiwuji]

It connected, i found out that the error is on the insert statement not the driver.
Thanks,
Kiwuji