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 >> mapguide-users@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@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
