Can't connect to Oracle database getting an exception

[Chrissirhc]

I can create a .udl file to test a connection to a database.

When I use visual studio .net I can also set the connection up. I drag and drop the connection on to my webform and also a button and a text box.

In the event method that is trigger for the button I run this.oldDbConnection1.Open();

When I run the webpage I get an exception:

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.


[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) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +131
WebApplication2.WebForm1.Button1_Click(Object sender, EventArgs e) in c:\inetpub\

http://wwwroot\webapplication2\webform1.aspx.cs:59

System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1263


Any ideas?

Thanks in advance,

Chris

 

[link9]

http://dbforums.com/arch/213/2002/10/521665

The answer to getting answered -- faq855-2992

 

[chiph]

You must install the Oracle client software on this machine. It provides the OCI layer needed by the Ora* classes.

Chip H.