Hello,
I am trying to see how Bentley Map works with Oracle Spatial 11g in terms of editing.
I have the Enterprise Edition set up on my system that has BM V8i SS-1 installed as well as PM V8i SS-1.
While trying to connect to Oracle Spatial in both these products, I get a message:
Error Opening Oracle Storage: A required DLL was not found. Please see the Message Center details for the list of dependencies.
Make sure you have the correct Oracle client version and that it is configured correctly. You will likely need the following directories in your path: C:\oracle\product\11.1.0\client_1\BIN C:\oracle\product\11.1.0\client_1\oci\lib\msvc\vc8
The Bentley.EngineeringContent.Storage.Oracle assembly depends on the following .NET assemblies: Bentley.ECObjects.2.0 Bentley.EngineeringContent Bentley.EngineeringContent.Geometry Bentley.EngineeringContent.SelectionCriteria Bentley.EngineeringContent.Storage Bentley.EngineeringContent.Storage.ConnectorLicensingFactory Bentley.EngineeringContent.Storage.ObjectToPermanentStorage Bentley.EngineeringContent.Storage.ObjectToRelationalStorage Bentley.EngineeringContent.Storage.Oracle.TopologyInfo Bentley.EngineeringContent.TopologyPosting Bentley.EngineeringContent.Utility Bentley.Geospatial.Base Bentley.Geospatial.GeometryConvert Bentley.Geospatial.SpatialReferenceSystems Bentley.Geospatial.SpatialReferenceSystems.Oracle10 Bentley.Geospatial.SpatialReferenceSystems.Oracle10.OCCI Bentley.Geospatial.SpatialReferenceSystems.Oracle10R2 Bentley.Geospatial.SpatialReferenceSystems.Oracle10R2.OCCI Bentley.Ogc.Base Bentley.Ogc.Geometry Bentley.Ogc.SpatialReferenceSystems Bentley.Platform Microsoft.VisualC mscorlib System System.Data System.Xml
Oracle is installed in d:\ and the home is set perfectly.
What could be the cause for this error?
Tx
SRG
rlingle, thanks for the information. I was not aware of this. Yes, this normally appears on a 64-bit OS with a 32-bit application as the Program Files directory is special then. However Microstation SelectSeries1 alos uses a default path with parenthesis but that can be changed at Microstation installation time.
Martin
Martin,
We ran into the same issue with parentheses in the MS path name. Seems that the Oracle client dlls can't be loaded from applications whose full path includes parentheses.
It can be quite confusing but would generally only show up on 64-bit systems. I used mklink to get around it because either the MicroStation or (I think) Map installer wouldn't let me install outside of "c:\program files (x86)\".
Here's one reference: http://ambergis.wordpress.com/2009/01/13/oracle-and-parentheses-x86/
Thanks everyone for your inputs and support. It was just a corrupt Oracle 11g installation that went unnoticed because of which Bentley Map was unable to get the ORACLE_HOME and other stuff.
Now things are fine after a fresh install of Oracle!
Hum, never heard of that. Would you have a reference handy, or maybe a problem report number ? I'd like to learn more about that.
Thanks,
SRG,
Does SQL Developer and/or other Oracle client apps work properly on the PC that Bentley Map is on? If so, try installing MicroStation V8i (SELECTseries 1) in a folder that does not contain parenthesis. We've heard reports of TNS errors and non-connect issues from Oracle due to the MicroStation folder name.