How to Connect to Oracle Database without installing Oracle Client

Yes we can connect our application to oracle db without oracle client being installed in our local pc, it can be done by using third party ADO.net data provider for oracle.

There are lot of providers available in the market, From my practical experience I suggest you to try this below provider

Devart DotConnect for Oracle/[^]

Probably you need Oracle.ManagedDataAccess.dll

Hi,
Whenever you want to talk directly with the Oracle server, the proprietary protocol called SQL*Net is needed, and that comes with "Oracle Client" installation.

If u really cannot install Oracle client, eg, on so many machines (remotely or not) that need to talk to the Oracle server, it is possible, then you need 3-tier, plus converting the VB.net to a browser - based application.

First tier is your client - which for our case, we can use a browser, which is installed in every computer nowadays. That will talk HTTP traffic with a tier 2 server (or called it our homebrewed application server). And you can used this tool to help out the conversion:

http://forums.asp.net/t/1178898.aspx?+Convert+VB+Net+Web+Site+to+Web+Application+Project[^]

Tier two: this is a Apache server with Oracle client installed, plus other component that can convert the HTTP traffic coming via Apache Server (or any HTTP server) to that of VB.net client. Just one tier 2 machine is needed.

Tier 3 is your database server.

Yes, you can connect to Oracle with installing the client.

You need to open a network connection to the Oracle Server, and write the code that talks to the Oracle database. This would be an extremely large effort. I'm not sure if Oracle document the protocol, or if you would have to reverse engineer it. It may change with each Oracle version and each patch, so might require a fair bit of maintenance.

Of course, Oracle provide software that already does this. It's called the Oracle Client. I recommend installing it instead.

If u really cannot install Oracle client, eg, on so many machines,you can use web service to connect oracle database.