Solved

Error Compiling ASP.NET Project Using Oracle

Posted on 2011-09-15
3
293 Views
Last Modified: 2012-05-12
I am attempting to compile an ASP.NET/C# project that was completed by another developer, whom is no longer with the organization I am with. I have never used Oracle databases before, however I have used MS SQL Server. When I attempt to just compile the project, which is the original working code on the company intranet site, I receive the error message "Error      3      Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.100, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies.". I also have received the warning stating "Warning      1      C:\Documents and Settings\thenthorn\My Documents\Visual Studio 2008\Projects\openservices\SiteInfoSolution\SiteInfo\MasterPage.master: ASP.NET runtime error: Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.100, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. " I am able to logon to the Oracle database using a third party tool, however I am unable to compile the same code that would load the site. I am able to view  the site on the intranet, but not via the local code that I have. Any help that anyone would be able to provide would be greatly appreciated. The attached code is the web.config file causing the error. (Reference line 41 of the attached file, where the error message is occurring.
 web.config
0
Comment
Question by:thenthorn1010
  • 2
3 Comments
 
LVL 9

Expert Comment

by:dexterrajesh
ID: 36544384
hi,

if check if the below assembly is there in the GAC or bin as applicable

Oracle.DataAccess, Version=10.2.0.100, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies

if not install it from: http://download.oracle.com/docs/html/E10927_01/InstallODP.htm
0
 

Author Comment

by:thenthorn1010
ID: 36544535
dexterrajesh,

I am using Win XP in order to develop this ASP.NET/C# web page, and I do see the DLL for Oracle.DataAccess in the C:\windows\assembly directory. The version on the file is 2.112.1.0. Just a lucky thought, would this be causing the issue because this DLL is outdated, or too old for the version of the program I will be editing?
0
 
LVL 9

Accepted Solution

by:
dexterrajesh earned 500 total points
ID: 36568479
its an incorrect version and hence throwing the error.. try getting the exact version installed...
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now