[mapguide-users] Oracle XE with ODBC?

[GordonL]

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.