Using ADO.Net, is there any way to connect to an Oracle database without
having the 'Oracle client tools' installed on the client PC?

I can see that if you connect using Oracle.DataAccess.Client or
System.Data.OracleClient, you will need the client tools installed, but what
if you use System.Data.OleDb or System.Data.Odbc?

Performance is not an issue, since I'll just be doing a simple read from a
view with few rows returned. But having client prerequisites is a rather big
issue.

Any simple way to solve this? Possibly just by including a few dll's?

I don't think so. I've always had to install the Oracle Client in order to
access Oracle.

Robin S.
----------------------------------
Show quoteHide quote

I remember that there was a company that had its own oracle client provider
that was much smaller and easier to install.
I guess you might google a bit around.

Show quoteHide quote

¤ Using ADO.Net, is there any way to connect to an Oracle database without
¤ having the 'Oracle client tools' installed on the client PC?
¤
¤ I can see that if you connect using Oracle.DataAccess.Client or
¤ System.Data.OracleClient, you will need the client tools installed, but what
¤ if you use System.Data.OleDb or System.Data.Odbc?
¤
¤ Performance is not an issue, since I'll just be doing a simple read from a
¤ view with few rows returned. But having client prerequisites is a rather big
¤ issue.
¤
¤ Any simple way to solve this? Possibly just by including a few dll's?
¤

Only if you're willing to invest in third-party libraries. I believe that the DataDirect and Core
Lab products do not require the Oracle client. They can talk directly to Oracle over TCP/IP w/o
using the OCI API.

The Microsoft and Oracle providers, .NET, OLEDB and ODBC all operate through the Oracle client's OCI
layer.


Paul
~~~~
Microsoft MVP (Visual Basic)

Jesper a écrit :
Show quoteHide quoteYou need an Oracle client installed for all "standard" providers
(Microsoft or Oracle, whether through native ADO .NET, ODBC or OLE DB
providers). But I think this client should suffice :
http://www.oracle.com/technology/tech/oci/instantclient/index.html. Only
  a few files. You may have to (manually) set some environment variables
too.

                    Mathieu Cartoixa

Thank you for all the replies.

I've looked into the 'instantclient', which will probably be what I'll end
up using. A bit of a shame that it adds 20Mb to my ClickOnce app, but
definately still preferable over Oracle standard client. The other 3'rd
party clients looked good, but too big a price tag for this project.

Datagrid does not update datasource efficiently
Using a Variable within a Connection String
Subquery in SqlDataSource failing
updating database views via tableadapter?
DbDataReadet.GetOrdinal() - duplicate column name