Oracle Error Occurred But Error Message
Contents |
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/Oracle, MySQL, Sybase, Informix and oracle error occurred but error message could not be retrieved from oracle other databases/Oracle Error Occurred, but error message could not
Test Connection Failed Because Of An Error In Initializing Provider Oracle Client And Networking
be retrieved from... Oracle Error Occurred, but error message could not be retrieved from Oracle. [Answered]RSS 5 replies Last post Mar 01, 2009 09:08 PM by wmec ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply Alekhya.Muvv... Member 5 Points 71 Posts Oracle Error Occurred, but error message could not be retrieved from Oracle. Feb 26, 2009 05:02 AM|Alekhya.Muvva|LINK I Have been getting the below error while running my program, The same Program was running in another system and it is not working in my computer. Could anyone tell me why this is happening? What could be the reason for this error? I am very new to .Net and C# System.Data.OleDb.OleDbException was unhandled by user code Message="Oracle error occurred, but error message could not be retrieved from Oracle." Source="Microsoft OLE DB Provider for Oracle" ErrorCode=-2147467259 StackTrace: at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) The below one is my program. protected void Button1_Click1(object sender,
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Oracle error occurred, but error message could not be retrieved from Oracle Want to Advertise Here? Solved Oracle error occurred, but error message could not be retrieved from Oracle Posted on 2009-04-20 Oracle Database Visual Basic Classic 1 Verified http://forums.asp.net/t/1390101.aspx?Oracle+Error+Occurred+but+error+message+could+not+be+retrieved+from+Oracle+ Solution 4 Comments 2,519 Views Last Modified: 2012-05-06 I have a vb6 application that is trying to connect to a oracle database my connection string: "Provider=MSDAORA; Password=test; User ID=test ; Data Source = T; Persist Security Info=True" I ran a tnsping on T and it works perfectly (and other applications can connect to T) the error occurs when the connection is opened On Error GoTo ErrorHandler https://www.experts-exchange.com/questions/24337665/Oracle-error-occurred-but-error-message-could-not-be-retrieved-from-Oracle.html Dim conn As New ADODB.Connection Dim cmd As New ADODB.Command Dim RS As New ADODB.Recordset conn.ConnectionString = ConStr conn.Open cmd.ActiveConnection = conn cmd.CommandText = "select 1 from test" cmd.CommandType = adCmdText RS.Open cmdCommand If RS.EOF = False Then RS.MoveFirst Do MsgBox (RS.Fields(0)) Loop Until RS.EOF = True RS.Close End If conn.Close ErrorHandler: MsgBox Err.Number & ": " & Err.Description Resume Next Select all Open in new window 0 Question by:james2432 Facebook Twitter LinkedIn Google LVL 1 Best Solution byjames2432 Decided to use another provider(and it works) "Driver={Microsoft ODBC for Oracle};Server=t;Uid=test;Pwd=test;" as for the MsgBox (conn.Errors(x).Description) I've already went throught them before Go to Solution 4 Comments LVL 15 Overall: Level 15 Oracle Database 5 Visual Basic Classic 1 Message Expert Comment by:OMC20002009-04-20 Try to add error processing, like the following: ErrorHandler: MsgBox (conn.Errors(0).Description) If top level error message is not informative enough, check all messages in errors collection Also check if there are
caused by something not that complex. As the case always is once you have the solution. So I https://blogs.msdn.microsoft.com/spike/2008/11/06/connecting-to-an-oracle-server-you-know-is-there-but-connection-still-fails-what-gives/ thought I would share some of the things that I've come across, and hopefully tha Connecting to an Oracle server you know is there. But connection still fails. http://www.orafaq.com/usenet/comp.databases.oracle.server/2005/12/05/0256.htm What gives. ★★★★★★★★★★★★★★★ Michael Aspengren - MSFTNovember 6, 20082 Share 0 0 For some reason I have lately got a few cases related to connecting to Oracle. All seems to be well in terms of Oracle being up and running etc, but still the client can't connect. To add to the confusion, there are different errors depending on how you (try) to connect to the Oracle server. I'll show you three ways of connecting, and their respective error oracle error occurred messages. So, for the sake of showing the different errors, we have 3 clients. Client 1 - A .Net application with the System.Data.OracleClient classes: --------------------------------------------------------------------------------------------------------------- static void Main(string[] args) { string cStr = @"Data Source=
when restarting application Re: "Oracle error occurred, but error message could not be retrieved from Oracle" error when restarting application From: Morff