(oracle)

[Clint Johnson]

Yes,

Connection to oracle spatial is another animal and will take some work 
to configure.  Your mapping example is incomplete; it makes no reference 
of any TSN entry.

http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto
That website describes how to configure your oracle connection

Important notes]
- Your mapserver must have support for oracle spatial connectivity; 
perform a GetCapabilites request to check.
- "you need Oracle client software in the server on which you are 
running mapserver."
- Your environment MUST have ORACLE_HOME, ORACLE_SID, and TSN_ADMIN 
correctly defined.
-  You must specify the ID/TNS entry within the CONNECTION tag of your 
layer:

CONNECTION "user/pwd at MYDB"

MYDB -- that is not an ip address; its the identifier that you need to 
create in your tnsnames.ora file.



Cheers,
Clints

-- 
Clint Johnson
Refractions Research Inc.
Cjohnson at refractions.net



Jochem Prins wrote:
> Hello all,
>
> currently I got a working map-file with some layers and want to extend it
> with some more data. The data from most layers is being retrieved from a
> local Oracle Spatial database and for most layers this is working as
> intended. However I seem unable to get another layer displayed, despite it
> being added to the mapfile and the data being available from the database.
> So far I suspect that my map file is wrong somehow, but I cannot find my
> problem. Perhaps someone can tell me what I am doing wrong here? 
>
> I have included the map file as attachment.
> The layer I want to have displayed is called gemeente2003.
>
> Thanks in advance,
>
> Jochem Prins
>
>