web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Connection to oracle d...
Microsoft Dynamics CRM (Archived)

Connection to oracle database

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all.

I'm trying to connect to a oracle database with a CRM plugin.

In the plugin I have a reference to Oracle.Managed.DataAccess which can be installed with nuGet. 

I have also installed  MSBuild.ILMerge.Task for Visual Studio to merge the dlls.

The plugin builds fine and I'm able to register it.

However when triggering the plugin, the plugin fails. It fails when referencing the oracle dll.

Ie:  OracleConnection connection = new OracleConnection(oracleConnectionString);

Thank you in advance.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    For the record:

    CRM 2016 on-premise.

    Business process error:

    Could not load file or assembly 'Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified. If you contact support, please provide the technical details.

  • Verified answer
    SergeyT Profile Picture
    SergeyT 310 on at

    You can't really merge 3rd party signed assemblies without having their key. Relevant SO answer: stackoverflow.com/.../using-ilmerge-to-merge-strongly-named-assemblies-into-a-single-strongly-named-as

  • Community Member Profile Picture
    Community Member on at

    Thank you for clearing that up SergeyT.

  • Community Member Profile Picture
    Community Member on at

    So the way to go now SergeyT, is that to register the Oracle ManagedDataAccess.dll in the GAC? And reference the dll from my plugin. Are there any guides to do this?

  • SergeyT Profile Picture
    SergeyT 310 on at

    There are some options:

    - as you stated GAC is one of them.

    - another is to put required assemblies in CRM .\bin\assembly folder. More details here: msdn.microsoft.com/.../gg309620.aspx

    - you can embed assembly instead of merging. More details: github.com/.../LibZ

    - use some middleware transport for handling calls from plugins to decouple dependencies. It can be any WCF\WebApi\Azure ServiceBus service that will handle calls from your plugins and go to oracle db or whatever.

    Last option has advantage in that it will require minimal refactoring if you would like to migrate into the cloud.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans