.net Connecting to Oracle

  • Thread starter Thread starter Ian Walsh
  • Start date Start date
I

Ian Walsh

I'm a bit new to using Oracle from .Net, tend to use SQLServer mostly.
I'm just looking for a bit of advice.

What do you need to get a connection working from .Net to Oracle. Do I
need to install the Oracle Client on my machine? The code I have is
looking for oci.dll, which I currently don't have.

Would what I install on the client change if I use the OLEDB or ODBC
components instead of the Microsoft Oracle data provider?

Thanks in advance.
 
Ian Walsh said:
I'm a bit new to using Oracle from .Net, tend to use SQLServer mostly.
I'm just looking for a bit of advice.

What do you need to get a connection working from .Net to Oracle. Do I
need to install the Oracle Client on my machine? The code I have is
looking for oci.dll, which I currently don't have.
Click to expand...

Yes, you need oracle client at least 8.1.6 (7 is recommned minimum),
Would what I install on the client change if I use the OLEDB or ODBC
components instead of the Microsoft Oracle data provider?
Click to expand...

No, you would still need oracle client.
 
You need the OracleClient software. Watch out if you are using 10g, as the
OracleClient does not work with it. You need ODP.NET instead.

As for can you get around client install. Only by connecting to Oracle
through some means other than a normal client connection (like web services
on the Oracle server). I would not aim for coding around this.


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Back
Top