Connecting to Oracle database

[Mrozik]

Hi
Is there possible to connect to Oracle database
using ADO.NET without installing Oracle Client software
on client machine?

Maybe anybody knows easy way of distributing and configuring
Oracle 9i Client software in installation package (.msi)
to use object from System.Data.OracleClient namespace to connect
to Oracle data?

My client wants to have client-server application writed
in MS .NET, using Oracle database but don't want
to install and configure Oracle 9i Client software on each machine
as a separate administration task - is it possible?

thanks for answers!

Pawel

 

[Guest]

AFAIK, the answer is no, but I have never tried. If there is a way, it would
be via a pure ODBC connection. One of the biggest issues is Oracle
connections is the way it handles security.

If client licenses is the issue and the load is not horrible (millions of
transactions per hour), one possible way to alleviate this issue is placing a
web service out on a server and having it call the database for the user. You
can set this up as ASMX or Remoting (less overhead, a bit more programming).


---

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

***************************
Think Outside the Box!
***************************

 

[Joshua Flanagan]

Not if you use System.Data.OracleClient.

You could use a managed data provider like DataDirect Connect, which
does not require the Oracle client software (they implement the Oracle
protocol in the provider).
http://www.datadirect.com/products/net/index.ssp

I have no personal experience with this product, so I cannot endorse it,
just letting you know it is out there.

I don't know how to bundle the Oracle setup into your own MSI project,
but I bet Oracle provides a way to do a "silent" install - meaning the
user just has to run the setup.exe and will not be prompted -- all
settings will be set to defaults in a config file.