Data Provider or other service returned an E_FAIL status Error

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.


 
Ads

Data Provider or other service returned an E_FAIL status Error

     

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()". 

Solution One:

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.

Solution 2:

While adding record, add some valid date into the database. You can set the value to now() when user clicks on the save button.

 

Advertisements

Ads
Share on Google+Share on Google+

Data Provider or other service returned an E_FAIL status Error

Posted on: February 9, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: Data Provider or other service returned an E_FAIL status Error   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
Vlada
January 12, 2012
Solution 3

I had same problem with FastReport and MySql Conncetor/ODBC 5.1 Your solution was excelent. Change date from "0000-00-00" as it is iregular to NULL, and force entered required date programaticaly. For my case regular data in this field is not desirable because it is unknown finish date.

Ads

 

Ads