<!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>Hi Again,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>my counties table does have a sdo_geometry data
type</FONT></DIV>
<DIV><FONT size=2>here is desc of my table</FONT></DIV>
<DIV><FONT size=2>SQL> desc
counties<BR> Name
Null? Type<BR> -----------------------------------------
--------
----------------------------<BR> GEOM
MDSYS.SDO_GEOMETRY<BR> COUNTY
VARCHAR2(31)<BR> FIPSSTCO
VARCHAR2(5)<BR> STATE
VARCHAR2(30)<BR> STATE_ABRV
VARCHAR2(2)<BR> FIPSST
VARCHAR2(2)<BR> LANDSQMI
NUMBER<BR> TOTPOP
NUMBER<BR> POPPSQMI
NUMBER</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I am wondering how mapserver knows where the database resides?
</FONT></DIV>
<DIV><FONT size=2>Where do I define my database connection
parameters??</FONT></DIV>
<DIV><FONT size=2>IS there any quick test to find out if mapserver is looking
into right database?</FONT></DIV>
<DIV><FONT size=2>My database is on remote machine and I'm running mapserver
from my machine...</FONT></DIV>
<DIV><FONT size=2>I also have oracle client on my machine talking to same
database.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I heartly appreciate your help!</FONT></DIV>
<DIV><FONT size=2>Kind 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 5:15
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [mapserver-users]
oracle8.1.7 and mapserver</DIV>
<DIV><FONT size=2></FONT><BR></DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2>Nida:</FONT></SPAN></DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2>Judging from your 'counties table with a column geom' it doesn't appear
to me you're using Oracle Spacial option. You will need to have that
option to work with MapServer. Is your 'geom' column of data type
SDO_GEOMETRY?</FONT></SPAN></DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff size=2>You
have to make sure Oracle Spacial option is in the database. By default,
when spacial option is installed you'll have an MDSYS user id and schema
associated with that user. If you don't see that, you'll have to install
it first. You should have an 'md' directory under $ORACLE_HOME.
Under md there is an admin directory which contains all installation
scripts.</FONT></SPAN></DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff size=2>Your
map file looks OK if your counties is a table contain geom column which is of
SDO_GEOMETRY data type.</FONT></SPAN></DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=246590317-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 9:48
AM<BR><B>To:</B> Yu-Hsin Chen;
mapserver-users@lists.gis.umn.edu<BR><B>Subject:</B> Re: [mapserver-users]
oracle8.1.7 and mapserver<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>