In was developing a form in Visual Basic and got the error "Data Provider or other service returned an E_FAIL status Error" while moving the Record Set forward.
On trying for the solution I found that there was a datetime field in the database whose default value was "0000-00-00 00:00:00". I changed the defualt value to Łnow()".
Make sure that null values are invalid date("0000-00-00 00:00:00") is not saved into datbase.
I used the following sql query to do so:
ALTER TABLE `mytable` CHANGE `record_createTime` `record_createTime` DATETIME NOT NULL DEFAULT 'now()';
After doing so program started working and error was gone.
While adding record, add some valid date into the database. You can set the value to now() when user clicks on the save button.
Posted on: February 9, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles