0

My project makes use of the Oracle.DataAccess.dll DLL and when I build and run my application it works fine on my PC, as I have added the reference in my project to it C:\Oracle\instantclient_11_2_dc\odp.net\bin\4\Oracle.DataAccess.dll

However when I run on another machine without this reference it fails installation with the following message.

unable to install or run the application

How do I include the DLL file in my project so it is deployed with it as as requirement, and doesn't reference my local file system?

Danny Cullen
  • 1,782
  • 5
  • 30
  • 47
  • 1
    possible duplicate of [How can I deploy a .NET application that uses ODAC without installing the whole component to the user?](http://stackoverflow.com/questions/3935808/how-can-i-deploy-a-net-application-that-uses-odac-without-installing-the-whole) – Christoph Mar 02 '15 at 16:40

2 Answers2

1

You have to install the Oracle client on the client machine if this is a client/server application. If it is web based application then it should be installed there.

I don't use the instant client as I end up wanting to edit the connections in the TNSNames.ora so I use the full or Administrator install. The client version will usually connect back or forward two Oracle versions but life is easier if you use the version appropriate to your database version.

kevinskio
  • 4,431
  • 1
  • 22
  • 36
1

You'll want to install the Oracle Data Access Components from here: http://www.oracle.com/technetwork/topics/dotnet/downloads/net-downloads-160392.html?ssSourceSiteId=ocomen on your dev machine AND any servers you plan on deploying to (or you can xcopy install per How can I deploy a .NET application that uses ODAC without installing the whole component to the user?). Also marked Q as duplicate to this one.

Community
  • 1
  • 1
Christoph
  • 4,251
  • 3
  • 24
  • 38
  • Is this a requirement, I've seen other software just include the DLL when I browse their root directory in Program Files. They don't seem to install to the machine as such. – Danny Cullen Mar 02 '15 at 16:37
  • Check out this Q : http://stackoverflow.com/questions/3935808/how-can-i-deploy-a-net-application-that-uses-odac-without-installing-the-whole I think you can use the instant client, but still need to xcopy the ODAC from above link, Will update answer. – Christoph Mar 02 '15 at 16:40