Could not load file or assembly 'Oracle.ManagedDataAccessDTC.DLL' or one of its dependencies

Question

we have an ASP.Net 4.5.2 application using the latest Oracle.ManagedDataAccess.dll from nuget with Entity Framework 5.

File version: 4.121.1.0

Product version: 4.121.1.20131211

When deployed to production environment (Windows Server 2008 r2 x64) all works fine, until we need distributed transactions.

Oracle documentation states that we need to provide Oracle.ManagedDataAccessDTC.dll (of same version, for specific platform x64) in order to get distributed transactions working.

Could not load file or assembly 'Oracle.ManagedDataAccessDTC.DLL' or one of its dependencies. The specified module could not be found.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.ManagedDataAccessDTC.DLL' or one of its dependencies. The specified module could not be found.

Stack Trace:

[FileNotFoundException: Could not load file or assembly 'Oracle.ManagedDataAccessDTC, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. ]

Answer 1

Install the Microsoft Visual C++ 2010 Redistributable.

If your server is a Windows Server 2008 R2 x64, install from this page: http://www.microsoft.com/en-us/download/details.aspx?id=14632 the with SP1 don't work for this server.

If your server is a Windows Server 2012 x64, install from this page: http://www.microsoft.com/en-us/download/details.aspx?id=13523