Oracle link problem

• Robert Morgan

  Mr or Mrs. 500

  Points: 527

  More actions

  January 11, 2007 at 3:05 pm

  #171754

  We have a web application which runs on IIS\sql server 2005 today we get this error, this error has happened once before and restarting the server seemed to right it until today now restart does nothing.

  application is called Loans

  All the oracle client installation is aok.

  Event code: 3005

  Event message: An unhandled exception has occurred.

  Event time: 12/01/2007 9:21:34 a.m.

  Event time (UTC): 11/01/2007 8:21:34 p.m.

  Event ID: c95ea58bceb947099bd90c9b444c174d

  Event sequence: 8

  Event occurrence: 1

  Event detail code: 0

   

  Application information:

      Application domain: /LM/W3SVC/1548204339/Root-1-128130204272812500

      Trust level: Full

      Application Virtual Path: /

      Application Path: C:\Inetpub\loans\

      Machine name: SQLDEV2

   

  Process information:

      Process ID: 3092

      Process name: w3wp.exe

      Account name: NT AUTHORITY\NETWORK SERVICE

   

  Exception information:

      Exception type: SqlException

      Exception message: Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "GHWPRD".

   

  Request information:

      Request URL: http://sqldev2/MemberPages/Search.aspx 

      Request path: /MemberPages/Search.aspx

      User host address: 172.30.1.100

      User: user1

      Is authenticated: True

      Authentication Type: Forms

      Thread account name: NT AUTHORITY\NETWORK SERVICE

   

  Thread information:

      Thread ID: 6

      Thread account name: NT AUTHORITY\NETWORK SERVICE

      Is impersonating: False

      Stack trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

     at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

     at System.Data.SqlClient.SqlDataReader.get_MetaData()

     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

     at Search.Button1_Click(Object sender, EventArgs e) in C:\Inetpub\loans\MemberPages\Search.aspx.vb:line 62

     at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

     at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

     at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

     at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

     at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

• January 15, 2007 at 8:00 am

  This was removed by the editor as SPAM

• Michael Riedmueller

  SSC-Addicted

  Points: 429

  More actions

  January 19, 2007 at 3:58 am

  #684230

  Hi,

  are you sure you always took care to close all your database connections you opened in eth application?

  I remember seeing similar effects in one off my projects when some were left open and caused such indeterministic problems.

  Michael