I am using the latest version of Access_JDBC30.jar as of 31 October 2007. I have a database in which there is a table which is causing me some problems. Whenever I attempt to insert a row in this table, the string value which should be in one of the columns is simply missing. The numeric values are entered correctly, and no error is returned. There is just no data in the column. The bug is easily demonstrated - I have a simple demo class which will show the problem if I can upload it somewhere along with the db in question. Can I upload to an FTP site for someone to look at, please>
|
You can zip and upload your sample into:
ftp site: ftp.hxtt.com
ftp user: anonymous@hxtt.com
ftp password: (empty)
login mode: normal (not anonymous)
ftp port:21
upload directory: incoming
transer mode: binary (not ASCII)
After upload, you can't see that upload file, but it has been upload.
|
I have uploaded this. Please let me know what you find.
|
Supported. Please download the latest package. Thanks.
|
Thanks, this seems to have solved the problem. What was causing it? Is there a bug-fix report?
|
It's resulted by the special record format of MS Access 95 & 97. When there's only one varchar column, and the record size beyound one special size, that insert bug for MS Access 95 & 97 will appear. Fixed.
|