I'm trying to use your Access driver in Coldfusion, but i'm getting the following error when trying to insert (select and update work ok)
commit failed. For more information, please use SQLException.getNextException().
- Failed to commit Record FFFFFF00 of table names! For more information, please use SQLException.getNextException().
- An invalid Access database page 16777215
I'm using a really simple table - names(id, name) to test and heres my test cfml code
insert into names (name) values ('foo');
If you can offer any advice that would be great.
Chris
|
Code got munged by the web hamsters, try again
<cftry>
<cfquery name="q" datasource="access" result="q">
insert into names (name) values ('foo');
</cfquery>
<cfdump var="#q#">
<cfcatch type="Any" >
<cfdump var="#cfcatch#">
</cfcatch>
</cftry>
|
>- An invalid Access database page 16777215
It seems that your mdb sample has some invalid information. You can use MS Access to repair/compact once. Then your issue should disappear.
|
Nope, this has not fixed the problem.
I get exaclty the same error message
An invalid Access database page 16777215
I also tried creating a new mdb file, new table and i also get the same error message
An invalid Access database page 16777215
My environment is Windows 7 Ultimate 64bit, Java 1.6.0_16, Adobe Coldfusion 9,0,0,251028 and Apache Tomcat 6.0.2
|
|
Please send us your mdb sample and test web page.
|
|
Please download the latest package, which has resolved a transaction INSERT issue.
|
Thankyou this seems to have solved the problem, i shall continue testing.
Many thanks
|
Main
webmaster@hxtt.com