[fdo-users] OGR Oracle connection problem

[Greg Boone]

Have you determined there are no missing libraries that the OGR provider requires? Using. 'ldd', etc...

OGR should successfully connect with Oracle Spatial databases.

Greg

From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Jan Malysiak
Sent: Monday, August 22, 2011 8:24 AM
To: FDO Users Mail List
Subject: [fdo-users] OGR Oracle connection problem

Hi,

I would like to connect MapGuide OpenSource to Oracle Spatial database, I use Ubuntu and I've already learned that KingOracle Provider does not work on Linux, so now I attempt to make a connection using OSGeo FDO Provider for OGR. When I test connection in MapGuide Maestro I get "The remote server returned an error: (559) MgFdoException.: An exception occurred in FDO component.". For more details, I looked at error log and that's what I read:

<2011-08-22T14:08:14>     -1388410000    MapGuide Maestro v2.1.4.5245    127.0.0.1    Administrator
 Error: An exception occurred in FDO component.
        Connect failed:
 StackTrace:
  - MgFeatureServiceHandler.ProcessOperation() line 83 file FeatureServiceHandler.cpp
  - MgOpTestFeatureSourceConnection.Execute() line 100 file OpTestFeatureSourceConnection.cpp
  - MgFdoConnectionManager.Open() line 893 file FdoConnectionManager.cpp

I've searched a lot for similar problems, but I couldn't find any working solution. I've tried multiple various configurations of connection parameters, I've tried also adding Oracle client path to LD_LIBRARY_PATH, but still all my attempts were unsuccessful.

I use:
MapGuide Open Source 2.1.0
FDO 3.4.0
MapGuide Maestro 2.1.4
Ubuntu 10.10
Oracle Instant Client 10.2.0.4

Thank you for any help.

Best regards,
Jan Małysiak
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20110822/50086523/attachment.html