Hi Gordon, Would it be possible for you to manually build the data resource XML with the necessary table name, lat and lon fields, etc. and then upload it via the mapagent? It looks like this information is stored in the config document which could be downloaded, modified and uploaded.
Doing this would probably be a work-around for the enumeration problem in Studio. Andy Morsell, P.E. Spatial Integrators, Inc. www.SpatialGIS.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of GordonL Sent: Friday, October 17, 2008 9:40 AM To: [email protected] Subject: SPAM-LOW: Re: [mapguide-users] Oracle XE with ODBC? Thanks for the feedback. Yes, my data is only numeric - meaning I am trying to draw points (X column and Y column) using the ODBC FDO Connector. I have used Uppercase USER. I have tried two connectors (both XE Client and XE Quick Client). I have tried users that are DBA (including system). When I click Test Connection with MapGuide Studio I get "Successful connection." I can connect to Oracle XE with PHP and get a report. I can connect to Oracle XE with ODBC with Access and Link Tables. I just can't enumerate the list of tables (so I can set the Lat/Long columns) with the ODBC Connection wtihin Studio.... Is having a user that is DBA too much? Am I trying to see too many tables in Oracle so nothing appears? thanks gordon zspitzer wrote: > > was your userame in uppercase? > > On Fri, Oct 17, 2008 at 5:45 AM, Gordon Luckett > <[EMAIL PROTECTED]> wrote: >> Hi, has anyone been able to enumerate the list of tables in Oracle XE 10g >> when connecting in MapGuide Studio with ODBC. >> >> None of the tables appear in the "Show Tables" area when making an OSGEO >> FDO >> Provider for ODBC. None of the tables are "spatial" just numeric with >> Lat >> and Long... >> >> >> I have tried many users (DBA rights) - and nothing. >> >> I know I can connect with ODBC because when I "LINK" tables to the ODBC >> with >> MS Access I can see the tables in Oracle XE. So the ODBC connection is >> fine. >> >> Has anyone had any luck with ODBC and XE seeing the tables in Studio >> 2009? >> >> Thanks >> Gordon >> >> >> >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> > > > > -- > Zac Spitzer - > http://zacster.blogspot.com (My Blog) > +61 405 847 168 > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://www.nabble.com/Oracle-XE-with-ODBC--tp20021723p20036886.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
