Error in the oracle connection OCI Handlers.

[Daniel Muñoz Castro]

Hello list.

I'm trying to connect to oracle data base in windows with ms4w.

I have this configured

D:\ms4w\Apache\cgi-bin>mapserv -v
MapServer version 4.10.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
OUTPUT=PD
F OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
SUPP
ORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER
SUPP
ORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG
INPUT
=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
DEBUG=MSDEBUG

and,

  LAYER
    NAME "Gerencia Oracle"
    STATUS ON
    TYPE POLYGON
    CONNECTIONTYPE ORACLESPATIAL
    CONNECTION "gis/gis at GIS"
    DATA "GEOMETRIA FROM GERENCIA3"
    DUMP TRUE
    CLASS
     STYLE
       OUTLINECOLOR 0 0 0
       COLOR 0 128 128
     END
    END
  END


and,

ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\geoazul\Application Data
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=DHCP-CORTES
ComSpec=C:\WINNT\system32\cmd.exe
GEOSERVER_DATA_DIR=C:\Program Files\GeoServer 1.5.1\data_dir
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\geoazul
LOGONSERVER=\\DHCP-CORTES
NUMBER_OF_PROCESSORS=1
ORACLE_BASE=D:\oracle\product\10.2.0
ORACLE_HOME=D:\oracle\product\10.2.0\client_1
ORACLE_SID=GIS
OS=Windows_NT
Os2LibPath=C:\WINNT\system32\os2\dll;
Path=D:\oracle\product\10.2.0\client_1\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\S
ystem32\Wbem;C:\Program Files\Support Tools\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PGLOCALEDIR=C:\Program Files\PostgreSQL\8.2\share\locale
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 7, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0207
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINNT
TEMP=C:\DOCUME~1\geoazul\LOCALS~1\Temp
TMP=C:\DOCUME~1\geoazul\LOCALS~1\Temp
TNS_ADMIN=D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
USERDOMAIN=DHCP-CORTES
USERNAME=geoazul
USERPROFILE=C:\Documents and Settings\geoazul
windir=C:\WINNT


and at last the error


*Warning*: [MapServer Error]: msDrawMap(): Failed to draw layer named
'Gerencia Oracle'. in *D:\ms4w\apps\exphp\htdocs\ctacont0.php* on line *155*

*Warning*: [MapServer Error]: msOracleSpatialLayerOpen(): Cannot create OCI
Handlers. Connection failure. Check the connection string. Error: . in *
D:\ms4w\apps\exphp\htdocs\ctacont0.php* on line *155*

*Fatal error*: Call to a member function saveWebImage() on a non-object in *
D:\ms4w\apps\exphp\htdocs\ctacont0.php* on line *156*

I have proved whit other programs and the db is totaly accesible.

I don't know what to do I hope some one can help me.

Thanks.
-- 
Salu2!.

Daniel Muñoz Castro
Ingeniero Catastral y Geodesta
Cel. 300 2174698
Casa. 4095990
Oficina. 7470001 Ext. 1141
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070814/8b892589/attachment.htm>