Unanswered: Problem with Insert into Access with Java JDBC ODBC driver
I need to write a simple java application that will be running on a machine with a user that might not be near any technical help. I want to use the java app as the front end and Access as the backend but I have a problem inserting data into the database.
The URL: String url = "jdbcdbc:gill_db";. This gill_db has been defined as an ODBC datasource and works fine when I select data from the database.
Registering the driver: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
The connection Connection con = DriverManager.getConnection(url, "", "");
There is no username and/or password necessary for this DB
The statment: Statement istmnt = con.createStatement();
I know this question is a few days old and you it is likely that you already solved it but this is my input just the same. I get these types of errors sometimes as well when working in Java, it is usually a field error, either data type, name or the number of arguments. Try wrapping your date field with the # symbol that access seems to love.