OleDb.OleDbException

VOliveira
VOliveira used Ask the Experts™
on
Has anybody run into this problem?
System.Data.OleDb.OleDbException: Unspecified error:
E_FAIL(0x80004005)


If we wait a few minutes, maybe 5-10 minutes and refresh the page the error
dissapeares.  We are using Oracle driver and OleDBDataAdapter to fill a
recordset and populate a datagrid.

We are using Oracle 8.1.5 and OraOLEDB.Oracle Povider

Help is very appreciateed
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hello. I suggest you, if you do not use any specisic features of Oracle data privder, try to use
Provider=msdaora (Microsoft OLEDB Provider for oracle).
I had not any problems when I was using msdaora + oracle 8.1.5

Regards,
zubok32
You should start by trapping the error, this gives you access to much more detailed error information... which might point you in the right direction.

if you're using c#, this is the syntax.

                                        try
                                        {
                                             MyCommand.ExecuteNonQuery();
                                        }
                                        catch (System.Data.OleDb.OleDbException ex)
                                        {
                                             foreach (OleDbError err in ex.Errors)
                                             {

                                                  MessageBox.Show("Error : " + err.Message);
                                             }
                                        }

Author

Commented:
We are using CLOB fields, as a specific feature of Oracle.
We store a xml node that can be upto 10000 characters(worse case).

Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Author

Commented:
We are using CLOB fields, as a specific feature of Oracle.
We store a xml node that can be upto 10000 characters(worse case).

Author

Commented:
We are using CLOB fields, as a specific feature of Oracle.
We store a xml node that can be upto 10000 characters(worse case).

Author

Commented:
We update to the most recent Oracle OLEDB Driver and we have not seen the error so far.  They say that the driver was not releasing memory.
Most Valuable Expert 2012
Top Expert 2008

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ/Refund

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

TheLearnedOne
EE Cleanup Volunteer
PAQed, with points refunded (200)

Computer101
E-E Admin

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial