[mapguide-users] Custom connection to DB Oracle

[Dave Wilson]

I don't believe connection strings work with Oracle. It's a bug.

Dave

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of sekko970
Sent: Thursday, July 29, 2010 6:19 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Custom connection to DB Oracle


Hi,
I need to connect to an Oracle DB using a connection string.

So, using Maestro, I created an new dataconnection FDO ODBC provider, then I
selected 'Custom connectionstring' option, and I wrote my connection string:

Driver=Oracle in OraHome92;Dbq=MyDbq;Uid=MyUid;Pwd=MyPwd;

The connection test returns 'provider reported no errors', but if I try to
'Configure Columns' or 'Rebuild schema', it returns ever the following
error:


  - MgResourceServiceHandler.ProcessOperation line 80 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\resource\ResourceServiceHandler.cpp
  - MgOpSetResource.Execute line 103 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\resource\OpSetResource.cpp
  - MgServerResourceService.SetResource line 713 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\resource\ServerResourceService.cpp
  - MgServerFeatureService.NotifyResourcesChanged line 1457 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services\feature\ServerFeatureService.cpp
  - MgFdoConnectionManager.RemoveCachedFdoConnection line 1006 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\FdoConnectionManager.cpp
Please try your operation later as the resource was busy:
Session:88aaa906-ffff-ffff-8001-000bcd727323_en_7F0000010AFC0AFB0AFA//de695c41-ffbb-4a02-832b-c95117280462.FeatureSource


The problem happens using FDO 3.3 and 3.4.


Can you help me?
Fabio

-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Custom-connection-to-DB-Oracle-tp5347249p5347249.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users