<div>Hi Zack,</div>
<div> </div>
<div>I am currently using MapGuide Open Source 2.1 and I've updated all the FDO to ver 3.4.</div>
<div> </div>
<div>The table has roughly 600 rows of data (for testing purposes), with 5 columns, and 2 of them are lat/long values. This company used to have all non-spatial data (properties listings) and we are planning to add lat/long values to those tables so we can map them out to do some spatial analysis for research purposes. I thought about using real Oracle spatial data, but because I have limited access to the database and the DBA is also located on the otherside of the country I would prefer to go to the 'easiest' way in terms of setting up the data within Oracle.</div>
<div> </div>
<div>I checked the access.logs file on the server and I get these:</div>
<div> </div>
<div><2011-03-31T16:28:23> 2184 MapGuide Maestro v2.0.0.4650 127.0.0.1 Administrator TestFeatureSourceConnection</div>
<div> </div>
<div>followed by EnumerateResourceData.1.0.0:1 and SetResource.1.0.0:3 when I clicked "test connection", and "configure columns" withn Maestro.</div>
<div> </div>
<div>Also, are we suppose to see the list of filenames on that listbox within the ODBC FDO menu after clicking "Test Connection"?</div>
<div> </div>
<div>Thanks in advance for all the help!</div>
<div>Eric</div>
<div> </div>
<div> </div>
<div class="gmail_quote">On Thu, Mar 31, 2011 at 4:22 PM, Zac Spitzer <span dir="ltr"><<a href="mailto:zac.spitzer@gmail.com">zac.spitzer@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi Eric,<br><br>it's always good to mention which version of MapGuide your using :)<br><br>how many rows in the table your trying to access? Can you<br>
check the server access.logs to see if your seeing a lot<br>of getDataRow requests?<br><br>We found a similiar bug in King Oracle yesterday, which will be fixed<br>in the final release of MapGuide 2.2<br><br>I would highly recommend using King Oracle and real spatial<br>
over lat lon columns, especially if your using anything beyond<br>very small amounts of data.<br><br>Regards<br><br>Zac<br>
<div>
<div></div>
<div class="h5"><br>On Fri, Apr 1, 2011 at 10:15 AM, Eric Poon <<a href="mailto:ericpoon124@gmail.com">ericpoon124@gmail.com</a>> wrote:<br>> Hi Everyone,<br>><br>> I am a GIS student currently working on a MapGuide OS web mapping project<br>
> for a real estate company. I am currently working on a connection setup to<br>> the Oracle Database. The Oracle database is located on another server, and I<br>> have both OracleInstantClient and the corresponding ODBC driver installed on<br>
> my local workstation (the one that holds the MapGuide Server).<br>><br>> On the Oracle side, I have non-spatial data where I have normal data with<br>> two extra columns that hold the lat/long values, the DBA has created a VIEW<br>
> for my user account to access and retrieve data. Knowing that I will have to<br>> define x,y within Maestro, I decided to use the ODBC FDO connection instead<br>> of the King Oracle. I first setup a System/User DSN for the Oracle<br>
> Connection with connection tested without problems. Then I defined a new<br>> data connection in Maestro 2.0 using ODBC FDO with DSN connection. The<br>> connection was tested within Maestro without any problems reported.<br>
><br>> I then proceed to Configure Column within Maestro, where I waited for 1-2<br>> min and Maestro returned an error saying Resource is busy. I tried<br>> connecting to the Database through OpenOffice Base using the same ODBC<br>
> connection and although I was not able to see the VIEW, I was able to see<br>> the other tables no problem.<br>><br>> My question is, is there any additional settings that I have to define<br>> within Maestro? Such as the ConnectionString? currently, my ConnectionString<br>
> is empty (I only enter information for userid, password, and DataSourceName.<br>> I assume if OpenOffice Base was able to connect and retrieve those table,<br>> then Maestro should have no problem in reading those tables as well.<br>
><br>> Any help will be appreciated!!<br>> Thanks,<br>> Eric<br>><br>> --<br>> View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/Retrieving-data-from-Oracle-for-MapGuide-OS-tp6228945p6228945.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/Retrieving-data-from-Oracle-for-MapGuide-OS-tp6228945p6228945.html</a><br>
> Sent from the MapGuide Users mailing list archive at Nabble.com.<br>> _______________________________________________<br>> mapguide-users mailing list<br>> <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>><br><br><br><br></div></div><font color="#888888">--<br>Zac Spitzer<br>
Solution Architect / Director<br>Ennoble Consultancy Australia<br><a href="http://www.ennoble.com.au/" target="_blank">http://www.ennoble.com.au</a><br><a href="http://zacster.blogspot.com/" target="_blank">http://zacster.blogspot.com</a><br>
<a href="tel:%2B61%20405%20847%20168">+61 405 847 168</a><br></font>
<div>
<div></div>
<div class="h5">_______________________________________________<br>mapguide-users mailing list<br><a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</div></div></blockquote></div><br>