Solved

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

Posted on 2014-04-16
11
1,389 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
More Than Just A Video Library

Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.

At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.

 

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

Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Question has a verified solution.

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

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

687 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