Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Spring Framework | Web Services | BioInformatics | Java Server Faces | Jboss 3.0 tutorial | Hibernate 3.0 | XML

Tutorial Categories: Ajax | Articles | JSP | Bioinformatics | Database | Free Books | Hibernate | J2EE | J2ME | Java | JavaScript | JDBC | JMS | Linux | MS Technology | PHP | RMI | Web-Services | Servlets | Struts | UML


 

Java Tutorials


 

 

Struts Tutorials

Struts Resources

Visit Forum! Post Questions!
Jobs At RoseIndia.net!

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.

 

                         

Ask programming questions?

 

 

Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 

Current Comments

5 comments so far (post your own) View All Comments Latest 10 Comments:

strSQL = "select * from employee "
rs1.CursorLocation = adUseClient
rs1.Open strSQL, cnWages, adOpenStatic, adLockReadOnly

X1.ReDim 0, rs1.RecordCount - 1, 0, 15

Posted by khurshid on Wednesday, 10.27.10 @ 13:18pm | #100503

similar error has occured in a running an application coded in VB .Actually the exe was fine and no error was found while compiling .. The exe was running for mor than 2 years without any problem..Suddenly i started facing error "Data Provider or other service returned an E_FAIL status Error " .

Solution: There is some problem associated with the network. It gets hung in middle so due to network issue hence returns an error.
We checked all the network but it was fine.. finnally restarted the server. AND IT WORKED...!

Posted by Ashwin on Wednesday, 07.14.10 @ 15:33pm | #98183

similar error has occured in a running an application coded in VB .Actually the exe was fine and no error was found while compiling .. The exe was running for mor than 2 years without any problem..Suddenly i started facing error "Data Provider or other service returned an E_FAIL status Error " .

Solution: There is some problem associated with the network. It gets hung in middle so due to network issue hence returns an error.
We checked all the network but it was fine.. finnally restarted the server. AND IT WORKED...!

Posted by Ashwin on Wednesday, 07.14.10 @ 15:32pm | #98182

i just changed cursor location and it works

Posted by nilesh on Friday, 04.24.09 @ 13:19pm | #87096

thank you for the solution

Posted by leonard aranjuez on Saturday, 03.28.09 @ 04:22am | #86302

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification

Tell A Friend
Your Friend Name

 

 
Browse all Java Tutorials
Java JSP Struts Servlets Hibernate XML
Ajax JDBC EJB MySQL JavaScript JSF
Maven2 Tutorial JEE5 Tutorial Java Threading Tutorial Photoshop Tutorials Linux Technology
Technology Revolutions Eclipse Spring Tutorial Bioinformatics Tutorials Tools SQL
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2007. All rights reserved.

[an error occurred while processing this directive]