Home Mysql Data Provider or other service returned an E_FAIL status Error
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

Data Provider or other service returned an E_FAIL status Error

Advertisement
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.

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.

 

Advertisement

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: February 9, 2008

Ask Questions?    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
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.
DMCA.com