[mapguide-users] SPAM-LOW: Re: Oracle XE with ODBC?

[GordonL]

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 &quot; for double-quotes
> instead?
> 
> Andy 
> 
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of GordonL
> Sent: Friday, October 17, 2008 12:26 PM
> To: mapguide-users at lists.osgeo.org
> 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: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of GordonL
>> Sent: Friday, October 17, 2008 9:40 AM
>> To: mapguide-users at 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
>>> <gordon.luckett at arrowgeo.com> 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 at 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 at 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 at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> 
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> 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.