iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

  • Facebook
  • Instagram
  • LinkedIn
  • Phone
  • Twitter
  • YouTube

Copyright © 2025 · iT Synergy·

Could not load file or assembly ‘Oracle.DataAccess’ or one of its dependencies. An attempt was made to load a program with an incorrect format.
Could not load file or assembly ‘Oracle.DataAccess’ or one of its dependencies. An attempt was made to load a program with an incorrect format. avatar

January 24, 2012 By Juan Camilo Zapata Montúfar Leave a Comment

If you are facing this same error “Could not load file or assembly ‘Oracle.DataAccess’ or one of its dependencies. An attempt was made to load a program with an incorrect format.” using the Oracle.DataAccess assembly in my case , and only if it happens using the iis version of your WCF service, but running it directly from Visual Studio works , then you problem is on the Application Pool on your IIS

Go to the Application Pool of your application on the IIS:

Select Advanced Settings:

And change Enable 32-bit Applications to TRUE

And finally make an IIS Reset

This option solve my problem.

Filed Under: IIS, Oracle Data Adapter, WCF Tagged With: An attempt was made to load a program with an incorrect format., Could not load file or assembly, Could not load file or assembly 'Oracle.DataAccess', Oracle DataAccess dependencies, Oracle dependencies, Oracle dll format, Oracle.DataAccess, WCF dll

Issues when working with the BizTalk Adapter for Oracle Database
Issues when working with the BizTalk Adapter for Oracle Database avatar

January 4, 2011 By Sonia Elizabeth Soriano Contreras Leave a Comment

Recently I’ve been working on a new project where we have to integrate Oracle within some workflows we are implementing using BizTalk Server 2010.

I have encountered several issues, so I preferred to document the solution as I got them solved.  Hope it helps!

What I needed to do was to have a Polling Receive Location Listening from an Oracle Database. So I had to first test the connection from Visual Studio 2010 and import the schemas, then I had to create the receive location, with Transport Type WCF-Custom and Binding Type OracleDbBinding.  Within the Visual Studio Solution I made a simple orchestration where I have a Receive Port (From Oracle DB) and a Send Port (FILE) so I could see the file that was being generating from the Receive Location.

So, this is how I got it working:

My Environment Configuration

I have my development environment configured as follows:

  • Windows Server 2008 R2
  • Visual Studio 2010
  • BizTalk Server 2010
  • WCF LOB Adapter SDK x64
  • BizTalk Adapter Pack for both x32 and x64 bit machines
  • Oracle 11g Client 11.0.7.0 for both x32 and x64 (One home for each).

Issue 1: Error “Connecting to the LOB System has failed”

When trying to connect to the oracle database while importing the schemas from the Consume Adapter Service Console you get this error:

In my case was because I had installed only the 64 bit version of the Oracle 11g Client. So I had to install the 32 bit version also.

After installing the 32 bit version, I tested it again and now it worked like a charm.

Issue 2: Unable to load OraMTS Error when configuring a Polling Receive Location

After I deployed my sample biztalk solution for the polling exercise, I had to create the Receive Location that was supposed to do the polling on the Oracle Database. The Polling Statement was set to a simple SELECT * FROM Sentence. The receive location was configured having the WCF-Custom Transport Type with the OracleDbBinding Binding Type.  The polling interval was set to 60 seconds.  After the receive location was configured, an error kept on showing in the Event Viewer saying that it was Unable to load OraMTS.

For this to be fixed it is necessary to install the Oracle Services for Microsoft Transaction Server.  Since I had both 32 and 64 oracle client versions installed, I installed the Oracle Services for MTS for both:

Make sure you restart your machine after this installation, otherwise the error will keep on happening.

Filed Under: BizTalk, BizTalk 2010 configurations, BizTalk Application, Integración, Oracle Data Adapter

Team


Marco
Antonio Hernández

Jaime
Alonso Páez

Luis
Carlos Bernal

Ana
María Orozco

Juan
Camilo Zapata

Diana
Díaz Grijalba

Carlos
Alberto Rueda

Sonia
Elizabeth Soriano

Alexandra
Bravo Restrepo

Bernardo
Enrique Cardales

Juan
Alberto Vélez

Diana
Paola Padilla

Jhon
Jairo Rodriguez

Jesús
Javier Hernández

Alejandro
Garcia Forero

Gustavo
Adolfo Echeverry

Carlos
Andrés Vélez

Yully
Arias Castillo

Brayan
Ruiz

Jimmy
Quejada Meneses

Natalia
Zartha Suárez

Josué
Leonardo Bohórquez

Oscar
Alberto Urrea

Odahir
Rolando Salcedo

Carolina
Torres Rodríguez

Juan
Mauricio García

Mario
Andrés Cortés

Eric
Yovanny Martinez

Tag Cloud

.NET (9) 940px (1) Analysis Services mdx (1) An attempt was made to load a program with an incorrect format. (1) ASP.NET MVC (1) Azure (3) Backup (1) BAM (7) BAM API (1) BAMTraceException (2) BI (3) BizTalk (24) Business Intelligence (6) C# (2) caracteristicas de publicacion (2) Content Editor (3) ESB (15) ESB Toolkit (3) General (4) habilitar caracteristicas (3) indexes (2) Integration Services (2) Master Page (3) MDX (2) MSE (11) net.tcp (2) Office 365 (2) Oracle (2) Performance Point (2) Public Website (2) Receive Location (2) SDK (2) Servicio Web (2) Sharepoint 2010 (2) SharePoint 2013 (4) SharePoint Online (2) SOA (8) Soap Fault (2) Sort Months MDX (2) SQL Server (2) Visual (2) Visual Studio 2010 (2) WCF (19) Windows (3) Windows 8 (17)

Categories

  • .NET (33)
  • Analysis Services (1)
  • ASP.NET MVC (2)
  • Azure (7)
  • BAM (9)
  • BAM PrimaryImport (3)
  • BigData (1)
  • BizTalk (77)
  • BizTalk 2010 configurations (57)
  • BizTalk Application (60)
  • BizTalk Services (13)
  • Business Intelligence (4)
  • Cloud (3)
  • CMD (1)
  • CodeSmith – NetTiers (2)
  • CommandPrompt (1)
  • CRM OptionSet mapping component (1)
  • Desarrollo de software (6)
  • develop (6)
  • developers (3)
  • DropBox (1)
  • Dynamics (1)
  • Enterprise Architect (1)
  • Entity Framework (1)
  • Errores BizTalk (2)
  • ESB (27)
  • ETL (1)
  • Event Viewer (1)
  • Excel Services (1)
  • Foreach loop container (1)
  • General (4)
  • Gerencia de Proyectos (2)
  • Google (1)
  • Grouped Slices (1)
  • Human Talent (1)
  • IIS (4)
  • Integración (6)
  • Integration Services (3)
  • KingswaySoft (1)
  • Lync (1)
  • MSE (13)
  • Office 365 (2)
  • Oracle Data Adapter (2)
  • Performance Point (4)
  • Picklist (1)
  • Pivot Table (1)
  • Procesos (1)
  • Pruebas (1)
  • Public Website (2)
  • Reports (1)
  • SCRUM (1)
  • SDK (2)
  • SEO (1)
  • Servicios (2)
  • Sharepoint (9)
  • SharePoint 2010 (10)
  • SharePoint 2013 (4)
  • SharePoint Online (2)
  • SharpBox (1)
  • Shortcuts (1)
  • Sin categoría (1)
  • SOA (50)
  • SQL (5)
  • SQL Server (3)
  • SQL Server Management Studio (1)
  • SSIS (3)
  • SSL (1)
  • SSO (1)
  • Tracking Profile Editor (2)
  • Twitter (1)
  • Uncategorized (1)
  • Virtual Network (2)
  • Visual Studio 11 (1)
  • Visual Studio 2010 (2)
  • Visual Studio Online (1)
  • VMware (2)
  • WCF (24)
  • Web (1)
  • Web Api (1)
  • Windows (5)
  • Windows 8 (11)
  • Windows Azure (2)
  • Windows Live Write (1)
  • Windows Phone (7)
  • Windows Phone 8 (1)
  • Windows Scheduler (1)
  • windows8 (2)
  • WindowsRT (3)
  • WP7 SDK (1)

Manage

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org