Transactionscope Oracle11g - causes error: [System.BadImageFormatException] = {"An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)"}

Running latest nightly build of Lightspeed (Licenced) Oracle 11g 64 bit (Enterprise Edition) Oracle Client 32 and 64 bit installed: MVC3 Project Visual Studio 2010

Using transactionscope with Lightspeed causes the aforementioned error.

Code snippet:

using System;
using System.Linq;
using System.Web.Mvc;
using Mindscape.LightSpeed.Web.Mvc;
using Mindscape.LightSpeed;
using System.Transactions;
...
        try
        {
            using (var transactionScope = new TransactionScope())
            {
                using (var uow = LightSpeedContext.CreateUnitOfWork())
                {
                    userDetailsViewModel.user = uow.FindById<User>(userId);  // Errors at this line
                   uow.SaveChanges();

                    uow.Dispose();

                }
                transactionScope.Complete();
                transactionScope.Dispose();
            }
        }
        catch (Exception e)
        {
            /* LOG Exception */
            return null; // return a oops page!
        }

If I remove the using for transactionscope like so:

        try
        {
           // using (var transactionScope = new TransactionScope())
            //{
                using (var uow = LightSpeedContext.CreateUnitOfWork())
                {                    
                    userDetailsViewModel.user = uow.FindById<User>(userId);
                   uow.SaveChanges();

                    uow.Dispose();

                }
           //     transactionScope.Complete();
           //     transactionScope.Dispose();
          //  }
        }
        catch (Exception e)
        {
            /* LOG Exception */
            return null; // return a oops page!
        }

The code runs through fine, without errors.

Any ideas?

Thanks

It seems that .Net is trying to load some assembly that is built to an especific plataform.

Try to force your main application to run in 32bit mode using corflags.exe assembliname.dll /32BIT+ and repeat the test.

If works, there is the problem. May only mindscape be able to fix it

Can you post a full stack trace of the exception please - this looks like an issue where the Oracle ADO.NET provider is probably trying to load a 64 bit library rather than a 32 bit version/

Thanks!
Jeremy

Hi Jeremy,

I've removed the 64 bit client and reinstalled 32 bit client. Same error occurs....

Exception Source: "System.Data.OracleClient"

Here is the full stack trace as requested:

at System.Data.OracleClient.OracleInternalConnection.Enlist(String userName, String password, String serverName, Transaction transaction, Boolean manualEnlistment) at System.Data.OracleClient.OracleInternalConnection.Activate(Transaction transaction) at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at ..getConnection() at Mindscape.LightSpeed.ConnectionStrategy.GetConnection() at Mindscape.LightSpeed.UnitOfWork.ƒ() at Mindscape.LightSpeed.UnitOfWork.PrepareCommand(IDbCommand command) at ...ctor(IUnitOfWork , IEnumerable1 ) at Mindscape.LightSpeed.Data.DataProviderAdapter.
(IUnitOfWork , IEnumerable1 , ProviderOptions ) at ..ƒ(AliasedTypeModel , IList1 , Query , IList ) at ..ƒ(UnitOfWorkBase , AliasedTypeModel , IList1 , Query , IList ) at .
.ƒ(UnitOfWorkBase , ICompiledParameterValues , IList ) at ..ƒ(UnitOfWorkBase , ICompiledParameterValues ) at Mindscape.LightSpeed.Querying.CompiledSqlQuery`1.Execute(IUnitOfWork , ICompiledParameterValues ) at Mindscape.LightSpeed.UnitOfWork.FindOne(Query query) at Mindscape.LightSpeed.UnitOfWorkBase.FindOne[TEntity](Query query) at Mindscape.LightSpeed.UnitOfWorkBase.FindById[TEntity](Object id) at Tens.Controllers.NewApplication.ApplicationController.PremisesDetails() in C:\TENSORACLE\TensOracle\TensOracle\Controllers\Application\ApplicationController.cs:line 181

I am assuming you are probably compiling for AnyCPU - can you try forcing x86 compilation and see if that solves the problem. The problem looks to be a mismatch between System.Data.OracleClient and the client libraries its looking to leverage.

Jeremy

Hi Jeremy,

I tried that and no luck - same issue

Thanks

Are you able to send through a copy of your project and I will see if I can reproduce the issue here under a couple of configurations to try and work out what needs to be changed to line thing up the Oracle libraries correctly.

Jeremy

Hi Jeremy,

Apologies for the late response.

I've been running some background checks and have found that installing the 32Bit version of ORACLE ODAC Client and choosing 'Oracle for .NET' as the connector plus configuring the project as x86, the transactionscope error is eliminated.

As you summised, it is a problem with 64 and 32Bit database connectors miss matching via Visual Studio 2010 and using Oracle11g 64Bit.

In case anyone else runs into this problem, the setup I'm using that works is:

Oracle11g 64Bit, ODAC Client 32Bit, VS 2010 building project as x86, Latest nightly build of Lightspeed.

Thanks

Doug