Hi Andy yes and I think the column names may need the tablename.column in double quotes too.
For example: <element name="Geometry" xColumnName="DegreesWLongitude" yColumnName="DegreesNLatitude" /> </complexType> may have to be: <element name="Geometry" xColumnName=''WELLSITES"."DegreesWLongitude"' yColumnName=''WELLSITES"."DegreesNLatitude"' /> </complexType> I've tried the nest the double quotes " with singles ' and then load the config files.. still nothing. Yikes, I hope I don't have to move my database out of Oracle... gordon Andy Morsell wrote: > > Might be a parser problem? How about using " for double-quotes > instead? > > Andy > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of GordonL > Sent: Friday, October 17, 2008 12:26 PM > To: [email protected] > Subject: RE: [mapguide-users] SPAM-LOW: Re: Oracle XE with ODBC? > > > 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: [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 >> >> > > -- > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > _______________________________________________ > 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--tp20021723p20040244.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
