newbie to oracle db - Connect asp.net app to oracle db

Question

User2119652040 posted

Hi,

Until yesterday I had good experience connecting asp.net web forms to sqlserver db. I am curious to know how to connect asp.net application to oracle db. Is there any material or website that walkthrough all these steps?

I have questions like ,

1. Do I have to install oracle 10g or 11g just like sqlserver db?

2. write odp.net like ado.net to connect to the database?

etc etc

Thanks in advance

Answer 1

User1366487642 posted

Yes,  You have to install oracle 10g or 11g or any other versions you like to use.

But not need to install anything like odp.net.

You can try following articles:

http://www.wrox.com/WileyCDA/Section/Connecting-to-Oracle-or-Access-from-ASP-NET-2-0.id-292764.html

http://www.shabdar.org/c-sharp/101-connect-to-oracle-using-asp-net-and-csharp.html

Please mark as answer if this helps you.

Answer 2

User-848116622 posted

Yes, you need to install oralce db.

To access it from the client, you should install oracle client

Answer 3

User269602965 posted

Oracle Installation Guide for Windows.

Carefully read section on recommendation to install Microsoft Loopback Adapter, create static IP on that adapter, disable all other network adapters, install oracle to the static IP, and then after reboot, re-enable the other network adapters.  Oracle needs static IP for best operation.

http://download.oracle.com/docs/cd/E11882_01/install.112/e16773.pdf

use ODP.NET and not the System.Data.OracleClient.  ODP.NET is faster and has more enterprise level features.  System.Data.OracleClient is no longer supported (deprecated) by Microsoft.  After database installation, you can install the latest version of ODP.NET and use the CLIENT INSTALL option, installing the client in a new Oracle home (directory path).  If the operating system and database are 64-bit, you can install the 32-bit ODP.NET and Client for 32-bit .NET applications (both thick client apps and web apps)

http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10767.pdf