Connecting Oracle Database with ASP dotnet

Hi,

While am trying to connect oracle database to VB dot net i am getting the following error.

I have two versions of the System.Data.OracleClient in Visual Studio when I
go to add refrence versions 1.0.5000.0 and 1.0.3300.0 . The error above is
using the 1.0.3300.0 version. When I switch to the newer version I get this
error:

System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater.
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.

I downloaded the Oracle client version 10i from the Oracle website. How do I
set the environment path for my application? Any help would be greatly
appreciated.

hello

It would be easier if you first try accessing the Oracle database
from within winforms application (which of course, runs under your
credentials) to pinpoint the problem.

Download ODP.NET, as Oracle has changed the database engine in 10g. Make sure you download the 10g version of ODP.NET. You will have to join Oracle's
TechNet, I believe, but it is free.

http://otn.oracle.net

Hi,
I think these links will help you in more detail regarding your problem with Oracle database & ASP.Net connectivity.
http://www.packtpub.com/ODP-dot-net-...-provider/book
and
http://forums.aspfree.com/microsoft-...lem-16458.html