Could not load file or assembly 'Oracle.DataAccess'

Question

I have a Windows Server 2008 x64 machine and have successfully connected a simple ASP.NET/C# application to an Oracle database using the ODAC 11g client. My next step, is adding this same oracle connection to a SharePoint web part (which is developed on the same machine). The SharePoint Server, Web Server, etc. all live on the same machine as well. I figured I could just add the Oracle.DataAccess reference to my SharePoint Web Part, add the oracle connection code, and be done... but ohh now... I am getting the following error when loading my web part through the browser with the oracle connection:

[BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format.]

Can someone please help me debug this? I have the assembly in the GAC with the correct version. For some reason it is not seeing it? I am confused as to why a simple ASP.NET/C# application would work fine, but now that it is up on SharePoint it does not work. Any ideas?

SPECFIC ERROR:

[TargetInvocationException: Exception has been thrown by the target of an invocation.] at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at Microsoft.SharePoint.WebPartPages.SPWebPartReflectionHelper.GetDefaultControl(Type controlType) at Microsoft.SharePoint.WebPartPages.BinaryWebPartDeserializer.LoadInitialWebPart() at Microsoft.SharePoint.WebPartPages.BinaryWebPartDeserializer.Deserialize() at Microsoft.SharePoint.WebPartPages.SPWebPartManager.CreateWebPartsFromRowSetData(Boolean onlyInitializeClosedWebParts)

[BadImageFormatException: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format.] at PortalOBIEEReportList.OBIEEReportList.OBIEEReportList..ctor()

No, Oracle 11g is installed on the same machine... I am running ODAC 11g client as well. I am just confused since my non-SharePoint ASP.Net/C# application connected just fine. It seems as though it is a 32-bit vs 64-bit issue here, but everything is 11g/64-bit. — Josh
– Josh, Commented Jul 9, 2010 at 2:35
I even tried setting the platform to x64 in the VS project, but no luck. — Josh
– Josh, Commented Jul 9, 2010 at 2:53

John Ptacek · Accepted Answer · 2010-07-09 12:12:28Z

1

You may need to enter a Safe Control setting for the oracle Data Access dll in the Web.Config file of your SharePoint application. The Safe Control setting explicitly identifies DLLs that the SharePoint runtime allows to be loaded.

The format is

<SafeControl Assembly="DLLName, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" 
    Namespace="DLLNameSpace" 
    TypeName="*" 
    Safe="True" 
    AllowRemoteDesigner="True" />

Information on adding a SafeControl.

A tool I use to help determine the Assembly name is .NET Reflector

answered Jul 9, 2010 at 12:12

John Ptacek

1,8861 gold badge15 silver badges20 bronze badges

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

Comments

Merin Nakarmi · Accepted Answer · 2012-05-21 12:33:30Z

0

The Build Platform Target must be 'ANY CPU' or x64.

answered May 21, 2012 at 12:33

Merin Nakarmi

3,4483 gold badges39 silver badges44 bronze badges

Collectives™ on Stack Overflow

Could not load file or assembly 'Oracle.DataAccess'

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related