<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><P>Hey Buddy,</P>
<P> I think you can use oracle locator if u r allowed to as i belive its built in with Oracle 10g and no need to go with extra Spatial License and all,but if u r restricted to use non-spatial data ,i don't think its big problem to get point using the X,Y Values from the Table.</P>
<P> </P>
<P>I think you check one more time as System DSN works perfectly and the screen shot provided by you doesn't give much idea so i unable to figure out for the same.</P>
<P> </P>
<P> </P>
<P>Max !</P>
<P> </P>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV style="FONT-SIZE: 13px; FONT-FAMILY: arial, helvetica, sans-serif">----- Original Message ----<BR>From: 0uch <hwayuyu@yahoo.com.tw><BR>To: mapguide-users@lists.osgeo.org<BR>Sent: Tuesday, August 12, 2008 5:36:20 PM<BR>Subject: Re: [mapguide-users] Create layer from oracle database without spatial data<BR><BR><BR>Thanks for your information.<BR><BR>I would like to, but the power to make decisions is not on me, I was been<BR>asked to do this.<BR><BR>BTW, I'm new with spatial data, is it take lots time to converting data to<BR>oracle spatial? <BR><BR>or it's hard to maintain the server (data is continu upgrade)?<BR><BR><BR><BR><BR>zspitzer wrote:<BR>> <BR>> is there any reason why your not just converting your data to oracle<BR>> spatial?<BR>> <BR>> <A href="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14255/sdo_objrelschema.htm#CBBFGHAE"
target=_blank>http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14255/sdo_objrelschema.htm#CBBFGHAE</A><BR>> <BR>> On Tue, Aug 12, 2008 at 3:03 PM, 0uch <<A href="mailto:hwayuyu@yahoo.com.tw" ymailto="mailto:hwayuyu@yahoo.com.tw">hwayuyu@yahoo.com.tw</A>> wrote:<BR>>><BR>>><BR>>><BR>>> Hi Max,<BR>>><BR>>> Yes I have tried the way that you told before, and this is what I see<BR>>> after<BR>>> clicking "show table".<BR>>> <A href="http://www.nabble.com/file/p18937853/mgs.jpg" target=_blank>http://www.nabble.com/file/p18937853/mgs.jpg</A><BR>>><BR>>> I have no idea how to continue in this situation, so I have only one way<BR>>> that use FDO provider for Oracle.<BR>>> Are there any solution for this problem?<BR>>><BR>>> T.H. Yu.<BR>>><BR>>><BR>>> max_samart wrote:<BR>>>><BR>>>> Hi,<BR>>>>
I think its not a big deal ,you can use MapGuide<BR>>>> Studio or Mastero for creating connection using the OsGeo<BR>>>> FDO Provider for ODBC and use DSN as oracle odbc driver<BR>>>> causes some error or you can also try King Oracle Provider<BR>>>> at <A href="http://www.sl-king.com/" target=_blank>www.sl-king.com</A> in order to create the points using the<BR>>>> non spatial Table,once you establish the connection and all<BR>>>> you have to create layer using that connection and thn<BR>>>> select the X and Y column which will create points from your<BR>>>> oracle table.<BR>>>> I hope it will help you out to get started !<BR>>>> Max !<BR>>>><BR>>>><BR>>>><BR>>>> ----- Original Message ----<BR>>>> From: 0uch <<A href="mailto:hwayuyu@yahoo.com.tw"
ymailto="mailto:hwayuyu@yahoo.com.tw">hwayuyu@yahoo.com.tw</A>><BR>>>> To: <A href="mailto:mapguide-users@lists.osgeo.org" ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR>>>> Sent: Thursday, August 7, 2008 10:15:38 AM<BR>>>> Subject: [mapguide-users] Create layer from oracle database without<BR>>>> spatial data<BR>>>><BR>>>><BR>>>> Hi all,<BR>>>> Is that passable to create layer from an oracle database that without<BR>>>> spatial data? (by studio 2009 or something else?)<BR>>>> If not , are there any kind of way that could build my point data (ex:<BR>>>> land-mark) on map?<BR>>>><BR>>>> I'll be very appreciate with any useful information<BR>>>><BR>>>> T.H. Yu.<BR>>>> --<BR>>>> View this message in context:<BR>>>> <A
href="http://www.nabble.com/Create-layer-from-oracle-database-without-spatial-data-tp18848865p18848865.html" target=_blank>http://www.nabble.com/Create-layer-from-oracle-database-without-spatial-data-tp18848865p18848865.html</A><BR>>>> Sent from the MapGuide Users mailing list archive at <A href="http://nabble.com/" target=_blank>Nabble.com</A>.<BR>>>><BR>>>> _______________________________________________<BR>>>> mapguide-users mailing list<BR>>>> <A href="mailto:mapguide-users@lists.osgeo.org" ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR>>>> <A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR>>>><BR>>>><BR>>>><BR>>>><BR>>>> _______________________________________________<BR>>>> mapguide-users mailing
list<BR>>>> <A href="mailto:mapguide-users@lists.osgeo.org" ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR>>>> <A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR>>>><BR>>>><BR>>><BR>>> --<BR>>> View this message in context:<BR>>> <A href="http://www.nabble.com/Create-layer-from-oracle-database-without-spatial-data-tp18848865p18937853.html" target=_blank>http://www.nabble.com/Create-layer-from-oracle-database-without-spatial-data-tp18848865p18937853.html</A><BR>>> Sent from the MapGuide Users mailing list archive at Nabble.com.<BR>>><BR>>> _______________________________________________<BR>>> mapguide-users mailing list<BR>>> <A href="mailto:mapguide-users@lists.osgeo.org"
ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR>>> <A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR>>><BR>> <BR>> <BR>> <BR>> -- <BR>> Zac Spitzer -<BR>> <A href="http://zacster.blogspot.com/" target=_blank>http://zacster.blogspot.com</A> (My Blog)<BR>> +61 405 847 168<BR>> _______________________________________________<BR>> mapguide-users mailing list<BR>> <A href="mailto:mapguide-users@lists.osgeo.org" ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR>> <A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR>> <BR>> <BR><BR>-- <BR>View this message in context: <A
href="http://www.nabble.com/Create-layer-from-oracle-database-without-spatial-data-tp18848865p18941706.html" target=_blank>http://www.nabble.com/Create-layer-from-oracle-database-without-spatial-data-tp18848865p18941706.html</A><BR>Sent from the MapGuide Users mailing list archive at Nabble.com.<BR><BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="mailto:mapguide-users@lists.osgeo.org" ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR></DIV></DIV></div><br>
</body></html>