[Mapserver-users] Oracle Spatial error

[Menno Schepel]

Rodrigo,

I have read your messages in the mapserv lists regarding the error
messages generated from within the Mapserv (v4.0) environment when
trying to connect to Oracle Spatial through a map file. I believe that
my problem is similar to the problem that Yu Hsin had before
(http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0202/msg00317.
html through
http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0202/msg00333.h
tml). 
I am able to connect to OracleSpatial using SQLPLUS or when I start up
Mapserv form the DOS prompt using the QUERY_STRING command with the same
arguments as the ones used in the CGI environment. I am also able to
generate an image from the Oracle Spatial layers using the map file and
shp2img from the prompt. However, when I try to connect to Oracle
Spatial using the CGI I am receiving the following errors:

msDrawMap(): Image handling error. Failed to draw layer named 'weg'. 
msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.

I saw a lot of solutions mentioning setting some environment var's
within Apache. I am working on a WinXP platform and I am using IIS as
webserver. Oracle and the Oracle Spatial database is stored locally. It
may be a stupid question, but it seems that if I am using IIS, there is
no need for me to get access through Apache? All the CGI processes run
under IIS. If so, then I should add somewhere the path or the reference
to the tnsnames.ora I guess, but where?
I would appreciate it if you could help sort this mess out.

Regards,

Menno Schepel