By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,302 Members | 1,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,302 IT Pros & Developers. It's quick & easy.

application using oracle database

P: n/a
We have applications that must connect to oracle databases. Is there a way
to connect using .NET that does not require installation of the Oracle
client on each PC?

I'm pretty sure java apps do not require the Oracle client. I'm hoping .NET
has some way of doing this as well.

If not, does anyone know of a way to incorporate the oracle client install
with a .NET application install? I guess I'm looking ofr some kind of merge
module that can be used to setup the oracle client during our app install.
Oracle clients are usually a pain for users to configure.

Thanks,
Jim
Nov 15 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Jim H" <no****@jimsaccount.com> wrote in message
news:uk**************@TK2MSFTNGP10.phx.gbl...
We have applications that must connect to oracle databases. Is there a way to connect using .NET that does not require installation of the Oracle
client on each PC?

I'm pretty sure java apps do not require the Oracle client. I'm hoping ..NET has some way of doing this as well.
For Java there is a Type 4 (pure java) JDBC driver, called the JDBC Thin
driver from Oracle.
For .NET the only "Type 4" Oracle driver is from Data Direct, and it's very
expensive and therefore useless and little used.

If not, does anyone know of a way to incorporate the oracle client install
with a .NET application install? I guess I'm looking ofr some kind of merge module that can be used to setup the oracle client during our app install.
Oracle clients are usually a pain for users to configure.


Get ODP.NET, Oracle's data provider (otn.oracle.com). It has an installer
(not an MSI, but an the Oracle Universal Installer), and will install both
the Oracle Client and the ODP.NET data provider. In addition you can try to
automate the install with a response file, and then launch it from your
installer. I've never done it, but it should be possible.

ODP.NET also supports some great features that the MS provider does not,
like Array Binding and PL/SQL Tables and BLOB's.

David
Nov 15 '05 #2

P: n/a
I have not used it, but the only .Net Data Provider in the market that does
not require the Oracle client (OCI layer, etc.) is the one from
http://www.datadirecttechnologies.com It uses a TCP/IP connection with the
wire protocol directly, like the thin JDBC drivers.

All the remaining are built on top of the OCI layer.

HTH,

Carlos Quintero

"Jim H" <no****@jimsaccount.com> escribió en el mensaje
news:uk**************@TK2MSFTNGP10.phx.gbl...
We have applications that must connect to oracle databases. Is there a way to connect using .NET that does not require installation of the Oracle
client on each PC?

I'm pretty sure java apps do not require the Oracle client. I'm hoping ..NET has some way of doing this as well.

If not, does anyone know of a way to incorporate the oracle client install
with a .NET application install? I guess I'm looking ofr some kind of merge module that can be used to setup the oracle client during our app install.
Oracle clients are usually a pain for users to configure.

Thanks,
Jim

Nov 15 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.