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
<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
[mailto:[EMAIL PROTECTED] 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
[email protected] <mailto:[email protected]>
http://lists.osgeo.org/mailman/listinfo/mapguide-users
--
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168
------------------------------------------------------------------------
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
