Thanks Andy, I did try that. I think it is an issue with XE requiring the double quotes around the tablename. For example, WELLSITES table requires "WELLSITES" - but it won't pass from XML...you end up with "WELLSITES"Type and "WELLSITES"Name in the config...
I going to have to experiment with this to see if I can hack it. It might be that I need the full schema too. ie. "GISUSER"."WELLSITES" for example...it is difficult to nest the double quotes when passing from XML and MapGuide with the config file. thanks gordon Andy Morsell wrote: > > 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: mapguide-users@lists.osgeo.org > 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 >>> mapguide-users@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >> >> >> >> -- >> Zac Spitzer - >> http://zacster.blogspot.com (My Blog) >> +61 405 847 168 >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> 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 > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://www.nabble.com/Oracle-XE-with-ODBC--tp20021723p20039592.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
