[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Frequent error occuring in Visual studio 2005

Posted on 2009-04-29
1
Medium Priority
?
448 Views
Last Modified: 2013-11-26
Hello,

Iam getting this error frequently when i execute the program in visual studio 2005.


Server Error in '/FMSMag' Application.
--------------------------------------------------------------------------------

Unspecified error
Oracle error occurred, but error message could not be retrieved from Oracle.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unspecified error
Oracle error occurred, but error message could not be retrieved from Oracle.

Source Error:


Line 148:        End If
Line 149:        ' ''---------------------
Line 150:        Return oleDBCommand1.ExecuteReader()
Line 151:    End Function
Line 152:
 

Source File: E:\sneha\softwares\FMSMag\FMSMag\App_Code\DAL\DBAccess.vb    Line: 150

Stack Trace:


[OleDbException (0x80004005): Unspecified error
Oracle error occurred, but error message could not be retrieved from Oracle.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +99
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +239
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +351
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +88
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +195
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +128
   System.Data.OleDb.OleDbCommand.ExecuteReader() +32
   DBAccess.ReadDB(String SQLstr) in E:\sneha\softwares\FMSMag\FMSMag\App_Code\DAL\DBAccess.vb:150
   functions.verify_menu_mode(String url, String job_id) in E:\sneha\softwares\FMSMag\FMSMag\App_Code\BAL\Admin\functions.vb:50
   Admin_password_change.Page_Load(Object sender, EventArgs e) in E:\sneha\softwares\FMSMag\FMSMag\admin\password_change.aspx.vb:107
   System.Web.UI.Control.OnLoad(EventArgs e) +127
   System.Web.UI.Control.LoadRecursive() +92
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3365

 
0
Comment
Question by:angnanesh
1 Comment
 
LVL 6

Accepted Solution

by:
M3mph15 earned 1500 total points
ID: 24266343
Hi,

I'm guessing that the error occurs when you og to execute the sql statement to execute the reader. My suggestion is to run the same query on the database with an oracle program such as TOAD or SqlPlus and see if you get a btter error message (which you should).

That or add in a try catch statement to catch the error and print it to screen.

Try
         _conn.Open()
         reader = command.ExecuteReader(CommandBehavior.CloseConnection)
Catch ex As Exception
       Respone.Write(ex.tostring)
        _conn.Close()
End Try

Hope this helps
-M3mph15
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
The PowerShell Core 6.0 of .NET release is just the beginning. The upcoming PowerShell Core 6.1 would have artificial intelligence and internet of things capabilities. So many things to look forward to in the upcoming release.
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question