DataDirect Connect for .NET vs. ODP.NET

[Mike G.]

I am trying to develop an application that connects to multiple oracle
databases.

I have developed the app using two different connection methods. "ODP.NET"
and "DataDirect Connect for .Net"

They both work fine, and they both performed about even speed wise.

Although deploying the project requires about 100MB when using ODP.NET and
less than 1 meg for DataDirect.

Does anyone of a way to connect to an Oracle database that does not require
the Oracle client installed. (Using .NET) Like DataDirect does.

All I need to do is "select" statements...

I figure if DataDirect can do it with a dll file that is only 300kb, Oracle
should be able to figure out a way to do it too. A client shouldn't be
required to have to download about 100megs of files just to perform simple
select statements.

I'm basically looking for a freeware solution. Unfortunatly DataDirect too
expensive for my company, it works great.

Thanks,

-Mike

 

[Carlos J. Quintero]

Hi,

No, AFAIK, the only .Net provider for Oracle that uses the wire protocol is
the one from DataDirect. Oracle has thin JDBC drivers that avoid also the
Oracle client, but their ODBC drivers, OLEDB Providers and .Net Data
Providers rely on the Oracle client libraries (OCI), as well as others from
other manufacturers (Microsoft, CoreLab,...)

Carlos Quintero