[ms4w-users] Error in the oracle connection OCI Handlers.

[Jeff McKenna]

One thing I notice is that you are using an older MS4W.  Try a newer one 
just in case (such as 
http://www.maptools.org/dl/ms4w/ms4w_2.2.6_beta.zip), do the required 
dll-swap steps 
(http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g), 
and retry.

--
jeff




Daniel Muñoz Castro wrote:
> 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
>