Is there a way to connect to a remote oracle DB from a client PC without installing oracle on the client ?
+4
A:
You need to download an ADO.NET driver for Oracle. Here's a step by step guide.
Darin Dimitrov
2010-01-05 10:22:36
Darin's answer is correct - just wanted to add that I found the ODAC xcopy packages listed at the links Darin gave to be particularly useful in the past. What I did was bundled the ODAC files into my MSI and then added an application environment variable to reference them. See this SO post http://stackoverflow.com/questions/923283/what-is-the-minimal-setup-required-to-deploy-a-net-application-with-oracle-clien
David Hall
2010-01-05 10:43:49
+1
A:
You don't need to install all of Oracle but only the ODBC driver.
Aaron Digulla
2010-01-05 10:22:46
A:
Everything depends upon the remote server. If the remote server is not permitting remote access to db then u cannot access it anyway.Instead u need to build some sort of webservice and deploy that web service to the same remote server. And call the web service into your app. The web service will act as a local app to db and will return your desired things, written in code. If its allowing remote access then as adviced above are good options.
I hope, you got it.
Amit Ranjan
2010-01-05 14:44:45