Connecting to Oracle DB from .NET/C#

Question

After finding this tutorial, I downloaded and extracted the files needed. But when I try to add their reference I get this error message:

A Reference to '..\oci.dll' could not be added. Please make sure that the file is accessible, and that it is a valid assembly or COM component.

Any help with this?

I think you would need Oracle.DataAccess fine print it says Once you have these files, simply copy them into the same directory as your executable — V4Vendetta
– V4Vendetta, Commented Apr 25, 2012 at 11:27

Antonio Bakula · Accepted Answer · 2012-04-25 13:04:28Z

3

You should download and install ODP.NET (Oracle Data Provider for .NET)

http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

For deployment look at the http://www.oracle.com/technetwork/issue-archive/2008/08-nov/o68odpnet-101744.html, but basically is xcopy deployment as V4Vendetta noted

Update: Client application need these dll's (32 bit version):

oci.dll 
Oracle.DataAccess.dll 
oraociei11.dll 
OraOps11w.dll

edited Apr 25, 2012 at 13:04

answered Apr 25, 2012 at 11:29

Antonio Bakula

20.8k7 gold badges81 silver badges106 bronze badges

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

1 Comment

Jason94 Over a year ago

Okey, ive downloaded the data provider. but i need to distribute my little program, is telling me right now that its missing Oracle.DataAccess. Any hot tips on what dlls that are needed?

Collectives™ on Stack Overflow

Connecting to Oracle DB from .NET/C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related