Hi Daniel,
This error (the "Error: ." problem) appear when the Mapserver CGI or
PHP Module can't find the Oracle environments.
Are you using Apache or IIS? If you are using apache you need to
define the environments inside the httpd.conf (using the setenv). Did
you already try to connect using PHP, without Mapserver, just to test?
Another issue is about the user that runs the webserver, the user have
permission to access the Oracle directory?
Best regards.
-------------------------------------------
Fernando Simon
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/[EMAIL PROTECTED]"
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