Re: Oracle Client and ADO.NET

Hello maz,

I'm considering using MS .net provider for oracle to connect to an
oracle 10g R1 DB.

I was reading thru some documents and it seems that an oracle client
must be installed so i can use this provider.

However, how do I go about installing the client? I have Developer
Suite 10g (9.0.4), but I am not able to select from the installer
which components to install. I am given only 4 options (J2EE
installation, Rapid App Dev Installation, etc... but no custom
option).

What are my options?

Another thing to consider in this is that there already exists a
default home installation (pretty old forms/reports 6i) which MUST be
present on our production environment. So I have to install the new
Oracle Client in another oracle home. Will I be able to use the .net
provider for Oracle in this scenario?

Of course I can use OLEDB/ODBC providers instead if this doesn't work.

Thanks


OleDB & ODBC providers also need the Oracle client installed. I've run some tests in the past with different versions of the OracleClient installed and this will cause you an enourmous headache for sure. I'd consider buildign a separate server with just the correct OracleClient version. You can download an installer from the Oracle website that contains just the client & providers for different systems. That download is your best bet I guess. The latest client can be found here (Oracle10g Release 2 ODAC 10.2.0.2.21)
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html

There are some 3rd party ADO.NET providers that acually let you select the Oracle_Home you want to use. The default driver from MS and Oracle don't have this ability I'm afraid. There are also some 3rd party ADO.NET providers that let you access Oracle without havign any oracle client installed at all. These drivers aren't free, but might be your easiest solution.

http://www.datadirect.com/products/net/net_for_oracle/index.ssp (100% managed, no Oracle client installation required)
http://www.crlab.com/oranet/ (Option to bypass oracle client)

Kind regards,

Jesse


.

Relevant Pages

  • Re: Asp.net / iis / oracle problem - never mind , i think i found
    ... Installed Oracle Client software on Server ... My DBA had to create synonyms for the account used to access the database to ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Asp.net / iis / oracle problem
    ... It is more than the libraries necessary for the Oracle SQL ... Oracle client and networking components were not found. ... later client software installation. ... An unhandled exception occurred during the execution of the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Oracle Client and ADO.NET
    ... I was reading thru some documents and it seems that an oracle client ... installation, Rapid App Dev Installation, etc... ... Of course I can use OLEDB/ODBC providers instead if this doesn't ...
    (microsoft.public.dotnet.framework.adonet)
  • Asp.net / iis / oracle problem
    ... box does not think that the Oracle Client is not installed... ... Oracle client and networking components were not found. ... later client software installation. ... An unhandled exception occurred during the execution of the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Oracle Client and ADO.NET
    ... installation, Rapid App Dev Installation, etc... ... Oracle Client in another oracle home. ... OleDB & ODBC providers also need the Oracle client installed. ...
    (microsoft.public.dotnet.framework.adonet)