10-30-2018 05:01 AM
We have a Server 2012 R2 machine, with .Net 4.6.2, Oracle Client 220.127.116.11.0 x64 and Oracle Client 12c 18.104.22.168.0 x86 installed. When trying to connect to Oracle database from M.App Ent Studio via Content\Vector Data New+, I get error
"Could not load file or assembly 'Oracle.DataAccess, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.: Oracle.DataAccess, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89b483f429c47342"
The Oracle.DataAccess.dll v188.8.131.52 exists in x64 Oracle Home and is referenced in system PATH variable.
From where can we get the later version of Oracle.DataAccess.dll? Why is M.App Ent looking for a specific version?
10-30-2018 06:03 AM - edited 10-30-2018 06:03 AM
The Oracle.DataAccess.dll must be available in the Global Assembly cache. (C:\Windows\Microsoft.NET\assembly)
Are you sure that the ODP.Net components are installed on this machine?
10-30-2018 06:55 AM
The Oracle Installer lists Oracle Data Provider for .NET 184.108.40.206.0 as installed.
The oracle.dataaccess.dll is in c:\windows\microsoft.net\assembly\gac_32 (version 1.121.2). It was not in assembly\gac_64 so I have created the folder and copied the dll from the x64 Oracle client.
This has made no difference. Thanks
10-30-2018 09:20 AM
The ODP.Net was installed as part of the oracle client 12c installation. I have since registered the oracle.dataaccess into the GAC (as per https://forums.asp.net/t/1664258.aspx?C+Windows+Microsoft+NET+assembly+GAC_64+Oracle+web+DataAccess) to no avail.
How would you ‘install it properly’?