Oracle problems - [Mapserver-users] WMS LAYERS= [SOLVED] But an Oracle one too!

[nicolas.fortin at ec.gc.ca]

Hi Fernando, thx for your answer

The server is Win2k with IIS.
I don't have the right to use debug log file on it yet so I can't say more
on the error message.
The connection and map work well on my workstation but not on the server.

Nick

-----Message d'origine-----
De : Fernando S. [mailto:simon at inf.univali.br] 
Envoyé : Tuesday, January 13, 2004 12:16 PM
À : nicolas.fortin at ec.gc.ca
Objet : RE: Oracle problems - [Mapserver-users] WMS LAYERS= [SOLVED] But an
Oracle one too!


Nick,
    Hi my name is Fernando Simon, I work in G10 (Laboratorio de 
computacao aplicada) we developer the drive that mapserv use to connect 
with Oracle Spatial. Well, I don't know if I can help you, but I will try.
    To solve the problems I need do some questions.
        The mapserv report more error mensages about the connection with 
Oracle?
        What system are you using? (S.O., Apache, Php version)
   
    Well, if you are using apache, the problem can be with apache 
configuration (http.conf).
    Are you set Oracle variables in http.conf?
    Look an example:
        SetEnv ORACLE_SID TEST
        SetEnv ORACLE_BASE /opt/oracle
        SetEnv ORACLE_HOME /opt/oracle/product/9.2.0
        SetEnv ORA_NLS33 /opt/oracle/product/9.2.0/ocommon/nls/admin/data

    Well, sorry my poor english. If you need some help, you can report me.
     Thank`s.

==================================================================
Fernando Simon - simon at cttmar.univali.br
==================================================================
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer G10 -
Laboratório de Computação Aplicada
Fone: 047 - 341 7960
http://g10.cttmar.univali.br
==================================================================



nicolas.fortin at ec.gc.ca wrote:

>Problem solved!
>The mapfile sent below is not exactly the right one, in the other, one 
>group has the same name as a layer.  By renaming the group, all is back 
>to normal.
>
>Thx for your help!
>
>Now we have a weird oracle error message from the server we're trying 
>to install mapserver, here it is:
>msDrawMap(): Image handling error. Failed to draw layer named '1_02'.
>msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.
>
>I searched the archive but found nothing...
>An idea? Someone...
>
>Nick
>  
>