It's mostly MS databases which allows spaces, Oracle definately doesn't On Dec 11, 2007 2:57 AM, Andrew DeMerchant <[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] <[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] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168
<<logo.gif>>
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
