Access table will not update from JSP script

[squidster]

I am having trouble with MS Access and JSP, basically scrip code is:-

String query = "INSERT INTO Service (description, regNo, vehicleMileage, serviceDate, totalPrice) VALUES ('Enter details here','"+ regNo +"',0,'01/01/2000',0.00)";
insStmt.executeUpdate(query);
insStmt.close();
out.print(query);
conn.close();

This execute with no errors and the debup out.print displays the query statemnent as you'd expect to see it. Trouble is that the record is not created in the table. You can create the record by inserting the SQL directly into MS Access though!!

(these are dumy values to make a point and regNo is an inserted parameter)

Anyone have any ideas?

thanks

 

[squidster]

'Sok

Found the problem, should have checked the ODBC DSN path details!!

Doh!