[mapguide-users] Using X,Y from Oracle

[Andrew DeMerchant]

Well, in any case the FDO provider doesn't seem to like them either. 
Just throwing that info out there in case it was of use to anyone - like 
I said, I don't know Oracle.

Zac Spitzer wrote:
> It's mostly MS databases which allows spaces, Oracle definately doesn't
>
> On Dec 11, 2007 2:57 AM, Andrew DeMerchant 
> <andrew.demerchant at gemtec.ca <mailto:andrew.demerchant at gemtec.ca>> wrote:
>
>     I have no experience with Oracle, but I can tell you that in order
>     to produce points from x and y data using the ODBC FDO, you need
>     to have the x and y fields as doubles, rather than single or
>     integers. You also can't have any spaces in the names of ANY
>     fields in tables you're using....same goes for table names. Using
>     that method, I can get my points to show up fine - using either
>     Access or SQL Server (both via OBDC).
>
>     Andrew
>
>
>
>
>     Brad Nesom wrote:
>>     I haven't seen the new MG's capability to produce points. I know that it was
>>     a capability in MG6.5. I'm sure someone else will have the answer.
>>     Brad
>>
>>     -----Original Message-----
>>     From: mapguide-users-bounces at lists.osgeo.org <mailto:mapguide-users-bounces at lists.osgeo.org>
>>     [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Kenneth,
>>     GEOGRAF A/S
>>     Sent: Monday, December 10, 2007 8:37 AM
>>     To: MapGuide Users Mail List
>>     Subject: [mapguide-users] Using X,Y from Oracle
>>
>>     I have tried to produce points from an Oracle database with only x and y 
>>     data, no SDO geometry.
>>     Using King.Oracle these tables do not appear, using the Autodesk 
>>     provider shows these, but does not allow for mapping with X/Y.
>>
>>     I then tried to load the Oracle as an ODBC connection.
>>     After waiting approximately 10 minutes after pressing save, the 
>>     FeatureSource is saved.
>>     After this, there are no tables listed in the FeatureSource.
>>
>>     Can I fix this somehow, or is it better to convert the columns to SDO?
>>
>>       
>
>     -- 
>     	*Andrew DeMerchant*
>     *Computer Technologist*
>     ph.1-877-2GEMTEC x.163
>     fax 506-453-9470
>
>     /GEMTEC Limited <http://www.gemtec.ca>
>     /191 Doak Road
>     Fredericton, NB, Canada
>     E3C 2E6
>
>
>     _______________________________________________
>     mapguide-users mailing list
>     mapguide-users at lists.osgeo.org <mailto: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
>