I was experiencing some update problems with the Access 3.0 JDBC driver, build date 9/5/2006. I decided to update to the latest build, dated on the website as 9/15. When I try to select from a table, the driver now complains that I've used an invalid format for a date column. The value that the driver complains about is "CPY" which is a value not in a date column, but in a column next to a date column.
I've already uploaded the database to your anonymous FTP server for you to use, it's called "Empty Copy of Duty Disability.mdb". Here is the sql command that is not working:
select * from tbl_be_tax_rtn
Before updating, I was occasionally getting an error message about my SQL statement "not having any parameter", but this was intermittent. Is this something you've seen before?
That issue exists only in the v2.0.015 JDBC30 package on September 15, 2006, because some new complemented code. Fixed. Thanks. Please download the latest package.
>Before updating, I was occasionally getting an error message about my SQL
> statement "not having any parameter", but this was intermittent. Is this
> something you've seen before?
Are you meeting "Your statment hasn't any parameter" message? It can be thrown by PreparedStatement and CallableStatement when you call PreparedStatement.setXXX(...) or CallableStatement.registerOutParameter(..) for a sql which hasn't any in/out parameter. What's your code?