CODEWITHSUNDEEP
biztalkbiztalk-2013
Jay
Jay

Reputation: 14481

Specific version oracle drivers for BizTalk bindings?

I'm trying to get the oracle bindings for a wcf-custom send port working. I get this error:

Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0

None of the installs on the oracle site seem to have this version. Any suggestions?

Upvotes: 0

Views: 178

Answers (3)

Jay
Jay

Reputation: 14481

I was able to get a workaround to operate but it's not ideal. I noted the 'add generated items' wizard was able to connect to oracle. The code to do this is in visual studio and is 32 bit code. So I knew the 32 bit code could connect. I created a 32 bit only host and have that much working.

I never got the 64 bit drivers to work but did not try Dan Field's redirect

Upvotes: 1

Dan Field
Dan Field

Reputation: 21661

timobr is right on if you're trying to connect to Oracle 11g. IF you're trying to connect to 12c, you'll need to update your machine.config bindings to redirect the request for the 11g DLLs to the 12c versions. See Sandro Periera's blog for more details; here's the relevant part to add to machine.config:

<runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <dependentAssembly>
        <assemblyIdentity name="Oracle.DataAccess"
          publicKeyToken="89b483f429c47342" />

        <bindingRedirect oldVersion="2.111.7.0" newVersion="2.112.1.2" />
      </dependentAssembly>
       </assemblyBinding>
</runtime>

Note this has to be done for all applicable .NET verions (including both x86 and x64).

Also note that if you're running on a 64-bit host, you'll need the 64-bit drivers - but the admin console is a 32 bit application, and will not work properly without the 32 bit drivers. However, installing both on the same machine is a bit challenging...

Upvotes: 3

timobr
timobr

Reputation: 31

That would be version 11g Release 7 (11.1.7). The 2 comes from .Net 2, I believe.

My notes on installing this for 32 bit hosts are (files downloadable from Oracle):

Get Oracle Developer Tools - ODTwithODAC1110621.zip

Take defaults and select all items. Will go to C:\app[yourusername]\product\11.1.0 by default.

Then install Patchset for ODT - p6890831_111070_Win32.zip

During the install select the previous installation folder from the earlier step (C:\app[yourusername]\product\11.1.0). Select the existing Oracle home! It might not be obvious from the screen that it is a drop down – do not select the folder.

That should give you Oracle.Data.Access 2.111.7.0 x86 in the Global Assembly Cache.

There should be 64bit versions available as well.

Upvotes: 3

Related Questions