Can I use ODP.NET without installing it ?

Question

0.00/5 (No votes)

See more:

Hi,
I'm developing an application in C# that will connect to Oracle database.
I decided to use ODP.NET. I have installed the whole ODAC package and everything works great. But now, I want to run that application on other computer (without ODAC package installed, but with oracle client).

Is it necessary to install that package on every computer where i want to run my app?
Can I use ODP.NET without installing it ?
I added only Oracle.DataAccess.dll as a reference to my project.

Thanks for help,

Posted 15-May-12 22:28pm

mnd017

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Comfizzy · Accepted Answer · 2012-05-15T23:30:00

Solution 1

you have to include the following dependencies on your project and make sure you copy them to the output directory.

VB

oci.dll
ociw32.dll
Oracle.DataAccess.dll
orannzsbb11.dll
oraocci11.dll
oraociicus11.dll
OraOps11w.dll

Hope it helps

Posted 15-May-12 23:30pm

Comfizzy

Comments

mnd017 16-May-12 5:53am

Thanks for answer. But, from where I have to copy them? It is important?

And, do i have to add all of them into my resources (the same as Oracle.DataAccess.dll) ?

Comfizzy 16-May-12 5:59am

These files comes with the ODAC package, check on the installation path. The Oracle.DataAccess.dll needs those files for it to work properly.

mnd017 16-May-12 6:09am

ok, thank you very much again. But to make sure, I have to add to resources only Oracle.DataAccess.dll, rest of dlls just have to be in the same dirctory as exe file and Oracle.DataAccess.dll, right ? I will check that in a moment.

Comfizzy 16-May-12 6:11am

That's correct, You can Mark the solution as an answer if it works.

mnd017 16-May-12 7:02am

Yes, i know. But now, I have ODAC package installed, so I can't really determine whether it works or not. It works even when I delete all this seven dlls from bin directory. So i have to find computer with no ODAC package installed.

mnd017 16-May-12 7:49am

So.. I've tried on other computer. And I think I've got a little bit bigger problem. Program throws an exeption 'ORA-12154'. On computer (where I've installed ODP.NET) path to TNSNAMES is: C:\app\OraHome_1\Network\admin\ and on computer where I'm testing (wihtout ODP.NET) is: C:\Oracle\product\11.2.0\client_1\network\admin. So the program cannot find tns file. Where can I set proper tns file path? Is there any config file where I can do that?