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

[Andy Morsell]

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