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