[mapguide-users] Retrieving data from Oracle for MapGuide OS

[Eric Poon]

Hi Everyone,

I am a GIS student currently working on a MapGuide OS web mapping project
for a real estate company. I am currently working on a connection setup to
the Oracle Database. The Oracle database is located on another server, and I
have both OracleInstantClient and the corresponding ODBC driver installed on
my local workstation (the one that holds the MapGuide Server). 

On the Oracle side, I have non-spatial data where I have normal data with
two extra columns that hold the lat/long values, the DBA has created a VIEW
for my user account to access and retrieve data. Knowing that I will have to
define x,y within Maestro, I decided to use the ODBC FDO connection instead
of the King Oracle. I first setup a System/User DSN for the Oracle
Connection with connection tested without problems. Then I defined a new
data connection in Maestro 2.0 using ODBC FDO with DSN connection. The
connection was tested within Maestro without any problems reported. 

I then proceed to Configure Column within Maestro, where I waited for 1-2
min and Maestro returned an error saying Resource is busy. I tried
connecting to the Database through OpenOffice Base using the same ODBC
connection and although I was not able to see the VIEW, I was able to see
the other tables no problem. 

My question is, is there any additional settings that I have to define
within Maestro? Such as the ConnectionString? currently, my ConnectionString
is empty (I only enter information for userid, password, and DataSourceName.
I assume if OpenOffice Base was able to connect and retrieve those table,
then Maestro should have no problem in reading those tables as well. 

Any help will be appreciated!!
Thanks,
Eric

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Retrieving-data-from-Oracle-for-MapGuide-OS-tp6228945p6228945.html
Sent from the MapGuide Users mailing list archive at Nabble.com.