Click here to Skip to main content
15,945,891 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi, I have developed a VB.Net application which connects to database, executes a query and fetches result in a text file, which is used for further processing. For that i had installed Oracle 11g on my machine.

Now i have to deploy this application to client where 50-60 users will be using it. We can't install Oracle Client on all the machines.
Without installing Oracle Client, we are getting "The "OraOLEDB.Oracle" Provider is not registered on local machine".

Is there any way to run the application without installing Oracle Client.
PS: Application has been developed on 64bit system.

Thanks in advance,

Regards,
Ashish
Posted
Comments
Nicholas Marty 15-Apr-14 4:55am    
Shouldn't you only need the "Oracle Data Provider" (ODP.NET) instead of a whole program for that?
AshishAgrawal123 15-Apr-14 5:17am    
Nicholas, can you please elaborate. As currently i am using "OleDbCommand" to connect and execute query.

Thanks,
Ashish
bluesathish 14-May-14 3:18am    
Yes Nicholas was correct, Check my solution No:4.

You cannot access an Oracle DB without some kind of client software.
But you can simply include the Oracle Instant Client[^] with your software binaries.
It comes in several flavours and the version you need is ODAC.
 
Share this answer
 
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/[^]
 
Share this answer
 
Probably you need Oracle.ManagedDataAccess.dll
 
Share this answer
 
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.
 
Share this answer
 
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.
 
Share this answer
 
Comments
AshishAgrawal123 15-Apr-14 5:04am    
Please read the problem statement again. This was not the expected solution.
If u really cannot install Oracle client, eg, on so many machines,you can use web service to connect oracle database.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900