Connecting Oracle Database with ASP dotnet

[Shashikant]

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.

[Ubimia]

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.

[Zecho]

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

[Kiran123]

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