[mapguide-users] Oracle XE with ODBC?

Kenneth Skovhede, GEOGRAF A/S ks at geograf.dk
Fri Oct 17 04:02:20 EDT 2008


The ODBC provider does not support spatial objects, just plain attributes.
You can map an x/y column pair to a point, but you won't get access to 
the SDO's.

There exists an specific Oracle provider, called King.Oracle, that 
supports the SDO's.

Regards, Kenneth Skovhede, GEOGRAF A/S



Gordon Luckett skrev:
> 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
>   


More information about the mapguide-users mailing list