Hexagon Geospatial
MENU

M.App Enterprise

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Frequent Contributor
Posts: 145
Registered: ‎02-17-2016

Adding Oracle data source fails

We have a Server 2012 R2 machine, with .Net 4.6.2, Oracle Client 12.2.0.1.0 x64 and Oracle Client 12c 12.1.0.2.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=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.: Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342‎"

 

The Oracle.DataAccess.dll v4.112.1.0 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?

 

Thanks Richard

Technical Evangelist
Posts: 178
Registered: ‎03-03-2016

Re: Adding Oracle data source fails

[ Edited ]

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?

Highlighted
Frequent Contributor
Posts: 145
Registered: ‎02-17-2016

Re: Adding Oracle data source fails

The Oracle Installer lists Oracle Data Provider for .NET 12.2.0.1.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

Technical Evangelist
Posts: 178
Registered: ‎03-03-2016

Re: Adding Oracle data source fails

It looks like it was not installed ... only adding the folder ... I don't think that works. Please install it correctly!

Frequent Contributor
Posts: 145
Registered: ‎02-17-2016

Re: Adding Oracle data source fails

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’?

Frequent Contributor
Posts: 145
Registered: ‎02-17-2016

Re: Adding Oracle data source fails

I have rolled back to Oracle Client 12.1.0 x64 and now can connect via the Vector data>Connection>New connection.

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Development Ticket through our Development Ticket Portal.