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

[GordonL]

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.