4

Is there a way to connect to a remote oracle DB from a client PC without installing oracle on the client ?

Improve this question

3 Answers 3

Reset to default
4

You need to download an ADO.NET driver for Oracle. Here's a step by step guide.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

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 stackoverflow.com/questions/923283/…
0

You don't need to install all of Oracle but only the ODBC driver.

Improve this answer

Comments

0

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.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.