Solved

Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies error

Posted on 2014-04-16
11
1,375 Views
Last Modified: 2014-04-29
I have an application that was developed in VS 2010 that was running fine in debug mode on my local machine.

I just had VS 2013 installed and now I get the "Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies" error if I try and debug in VS 2010.  

I get the same error if I try and debug in VS 2013.  

The Oracle.DataAccess.dll file exists in the bin folder of the project and is version 4.112.3.0.  The same file (same version) exists in C:\Windows\Microsoft.Net\assembly\GAC_32\Oracle.DataAccess\v4.0_4.112.3.0_89b483f429c47342.

The VS 2013 install obviously changed something but I don't know what.  Any ideas on how to fix this problem?
0
Comment
Question by:dyarosh
  • 7
  • 4
11 Comments
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 40003919
Take a look in the Reference node of Solution Explorer and see if any of the dll's have an informational icon next to the offending dll. If there is then place your cursor on it and right click and remove it. The add the dll back in by adding a reference to the project.
0
 

Author Comment

by:dyarosh
ID: 40003988
None of the DLLs in Reference have an information icon next to them.
0
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 40004019
You state, "I just had VS 2013 installed and now I get the "Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies" error if I try and debug in VS 2010.", so are you saying that it no longer is working in VS 2010 as well as VS2013?
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

Author Comment

by:dyarosh
ID: 40004039
That is correct.  I cannot debug under VS 2010 or VS 2013.  If I deploy my application to a web server, the application runs without any errors.
0
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 40004070
Well then I am at a lost seeming installing VS 2013 will not interfere with other VS install, they all can coexist.

When you opened the project in VS 2013 did it go through a upgrade process? if it did, did it have any errors? Are you opening this upgraded project in VS 2010?
0
 

Author Comment

by:dyarosh
ID: 40004081
The project did not go through an upgrade process when opened in VS 2013.  I am able to open the project in VS 2010 and VS 2013.
0
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 40004099
Do you have a copy of the project like in Version Control that was not open in VS 2013 and try to run that in VS 2010.
0
 

Author Comment

by:dyarosh
ID: 40004207
I did that and I still get the same error.  I think the problem is with Oracle Data Access Components.  It looks like I may now have two versions of that on my machine.  I am going to try and uninstall the newer version and see if that solves my problem.
0
 

Author Comment

by:dyarosh
ID: 40004683
I uninstalled both versions of the Oracle Data Access Components and reinstalled the version that was there before the VS 2013 install.  Still no luck.  I get the same error message.

I will be away for the next 5 days and will check back when I am back in the office.
0
 

Accepted Solution

by:
dyarosh earned 0 total points
ID: 40020678
I discovered the problem.  When I added Oracle.DataAccess as a Reference, the Copy Local flag was set to True.  Setting this value to False resolved the problem.
0
 

Author Closing Comment

by:dyarosh
ID: 40029080
I discovered the answer on my own.
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question