[mapserver-users] oracle8.1.7 and mapserver

[Yu-Hsin Chen]

Nida:
 
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?
 
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.
 
Your map file looks OK if your counties is a table contain geom column which is of SDO_GEOMETRY data type.
 
Yu-Hsin

-----Original Message-----
From: nida Khan [mailto:nida at webstar.co.uk]
Sent: Friday, November 15, 2002 9:48 AM
To: Yu-Hsin Chen; mapserver-users at lists.gis.umn.edu
Subject: Re: [mapserver-users] oracle8.1.7 and mapserver


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 at 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 ----- 
From: Yu-Hsin Chen <mailto:ychen at yorktel.com>  
To: nida Khan <mailto:nida at webstar.co.uk>  ; mapserver-users at lists.gis.umn.edu 
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 at webstar.co.uk]
Sent: Friday, November 15, 2002 6:29 AM
To: mapserver-users at 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.
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20021115/de28672b/attachment.html