Oracle client and networking components were not found
456957Oct 12 2005 — edited Oct 5 2007sir,
I am developing my project and i am getting the following error. i have oracle 10g database in my system and developing .net forms. there is an other system of my friend. in his system it is working perfectly. he has the same configuration as i have. we haave windows XP as OS. i have loaded the 10g from his system to my system.database and .net both are installed on my system only.it is a standalone pc. i have tried so many time but not able to fix my problem. in his system my forms are working perfectly. so kindly help me out to fix my problem. here is the error i am getting.
------------------------------------------------------------------------------------------------------------------------
Server Error in '/exp' Application.
________________________________________
Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.
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: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.
Source Error:
Line 56:
Line 57: con= new OleDbConnection("Provider=MSDAORA.1;User ID=scott;Password=Tiger");
Line 58: con.Open();
Line 59: cmd=new OleDbCommand("Insert into dept values(50,'ram','ravi')",con);
Line 60: int sa= cmd.ExecuteNonQuery();
Source File: c:\inetpub\wwwroot\exp\webform1.aspx.cs Line: 58
Stack Trace:
[OleDbException (0x80004005): Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
System.Data.OleDb.OleDbConnection.InitializeProvider()
System.Data.OleDb.OleDbConnection.Open()
exp.WebForm1.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\exp\webform1.aspx.cs:58
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
________________________________________
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
-----------------------------------------------------------------------------------------------------------------------
Please help me..........................