<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>I gave wrong example! :(</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>here is the right example</FONT></DIV>
<DIV><FONT size=2>layer defination</FONT></DIV>
<DIV><FONT size=2>LAYER<BR> NAME counties<BR> TYPE polygon<BR>
STATUS default<BR> MAXSCALE 1000000<BR> CONNECTIONTYPE
oraclespatial<BR> CONNECTION <A
href="mailto:'scott/tiger@PHAR'">'scott/tiger@PHAR'</A><BR> DATA "GEOM
from counties"<BR> CLASS<BR> NAME
'county'<BR> COLOR 220 224 230<BR>
OUTLINECOLOR 0 0 0<BR> END<BR> END</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>where I have counties table with a column geom</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>very anxious!</FONT></DIV>
<DIV><FONT size=2>Regards</FONT></DIV>
<DIV><FONT size=2>Nida.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ychen@yorktel.com href="mailto:ychen@yorktel.com">Yu-Hsin Chen</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=nida@webstar.co.uk
href="mailto:nida@webstar.co.uk">nida Khan</A> ; <A
title=mapserver-users@lists.gis.umn.edu
href="mailto:mapserver-users@lists.gis.umn.edu">mapserver-users@lists.gis.umn.edu</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, November 15, 2002 1:34
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [mapserver-users]
oracle8.1.7 and mapserver</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2>Nida:</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff size=2>You
need to compile MapServer with oraclespacial.</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff size=2>Your
Oracle RDBMS needs to have Spacial option loaded. Hopefully you've
already got this part, it is a good learning curve if you
havn't.</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff size=2>What
web server are you using? You might need to modify the configuration a
little.</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff size=2>Once
you have all the correct environment and settings it WILL work. I'm
running MapServer on a Mandrake Linux server accessing Oracle 8.0.5 data on a
UnixWare server through CGI.</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2>Yu-Hsin</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> nida Khan
[mailto:nida@webstar.co.uk]<BR><B>Sent:</B> Friday, November 15, 2002 6:29
AM<BR><B>To:</B> mapserver-users@lists.gis.umn.edu<BR><B>Subject:</B>
[mapserver-users] oracle8.1.7 and mapserver<BR><BR></FONT></DIV>
<DIV><FONT size=2>Hi Everyone,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Is there anyway to connect to Oracle 8.1.7 database on
Solaris via Mapserver?</FONT></DIV>
<DIV><FONT size=2>I've compiled Mapserver with Postgress, but have no idea
how to do it for Oracle now!</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I would really appreciate if anyone can guide me to right
documentation or just give me some codes!!!!</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Looking forward for your replies</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Regards</FONT></DIV>
<DIV><FONT size=2>Nida.</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>