You need to create a connection profile for the oracle client so that you can connect with username and password that is not ASPNET. I would stay away from giving the ASPNET account rights to your Oracle database on another machine - that's a major nightmare scenario.
Do a search here on Oracle and look for posts from Mark McCasland and Kelly Conway on how to set up a configured Oracle connection - it's a PITA and needs to be done on every client machine, but that helped me get a connection to Oracle going.
Regards,
+++ Rick ---
>Perhaps I should be posting this in the "ASP.NET in general" category...
>
>I have a Windows Form that connects to an Oracle database and everything works great. I also have an ASP.NET page that calls the same business object that my Windows Form does but I get the following error when I click on the button on my aspx page that fires the call to my business object:
>
>"Oracle client and networking components were not found. These components..."
>
>I since found some MS Knowledge Base articles (Q306158 in particluar) that mention different approaches of impersonation. I've tried both adding...
>
> <system.web>
> <identity impersonate="true" />
> </system.web>
>
>and
>
> <system.web>
> <identity impersonate="false" userName="ASPNET" password="password"/>
> </system.web>
>
>...to my web.config file (its
element contains exactly what I have from my app.config file's element) and I continue to get the same Oracle related error message.
>
>I made changes to my ASPNET user account based on this thread as well thinking that might be the problem:
>http://p2p.wrox.com/archive/aspx_beginners/2002-09/4.asp
>
>Same resulting error message.
>
>I'm sure that the problem lies somewhere with my ASPNET user account since everything works just fine from within my Windows Forms.
>
>Thanks for any help!
>Clay
