<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Daniel,<br>
This error (the "Error: ." problem) appear when the Mapserver CGI
or PHP Module can't find the Oracle environments. <br>
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?<br>
Best regards.<br>
<br>
-------------------------------------------<br>
Fernando Simon<br>
<br>
Daniel Muñoz Castro wrote:
<blockquote
cite="mid:960cb7fb0708140923w6862f497i4ab45ce543566717@mail.gmail.com"
type="cite">Hello list.<br>
<br>
I'm trying to connect to oracle data base in windows with ms4w.<br>
<br>
I have this configured<br>
<br>
D:\ms4w\Apache\cgi-bin>mapserv -v<br>
MapServer version 4.10.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
OUTPUT=PD
<br>
F OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE
SUPPORTS=WMS_SERVER SUPP<br>
ORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT
SUPPORTS=WCS_SERVER SUPP<br>
ORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS
INPUT=JPEG INPUT
<br>
=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
DEBUG=MSDEBUG<br>
<br>
and,<br>
<br>
LAYER<br>
NAME "Gerencia Oracle"<br>
STATUS ON<br>
TYPE POLYGON<br>
CONNECTIONTYPE ORACLESPATIAL
<br>
CONNECTION "gis/gis@GIS"<br>
DATA "GEOMETRIA FROM GERENCIA3"<br>
DUMP TRUE<br>
CLASS <br>
STYLE<br>
OUTLINECOLOR 0 0 0<br>
COLOR 0 128 128<br>
END<br>
END <br>
END
<br>
<br>
<br>
and,<br>
<br>
ALLUSERSPROFILE=C:\Documents and Settings\All Users<br>
APPDATA=C:\Documents and Settings\geoazul\Application Data<br>
CommonProgramFiles=C:\Program Files\Common Files<br>
COMPUTERNAME=DHCP-CORTES<br>
ComSpec=C:\WINNT\system32\cmd.exe<br>
GEOSERVER_DATA_DIR=C:\Program Files\GeoServer 1.5.1\data_dir<br>
HOMEDRIVE=C:<br>
HOMEPATH=\Documents and Settings\geoazul<br>
LOGONSERVER=\\DHCP-CORTES<br>
NUMBER_OF_PROCESSORS=1<br>
ORACLE_BASE=D:\oracle\product\10.2.0
<br>
ORACLE_HOME=D:\oracle\product\10.2.0\client_1<br>
ORACLE_SID=GIS<br>
OS=Windows_NT<br>
Os2LibPath=C:\WINNT\system32\os2\dll;<br>
Path=D:\oracle\product\10.2.0\client_1\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\S<br>
ystem32\Wbem;C:\Program Files\Support Tools\
<br>
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH<br>
PGLOCALEDIR=C:\Program Files\PostgreSQL\8.2\share\locale<br>
PROCESSOR_ARCHITECTURE=x86<br>
PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 7, GenuineIntel
<br>
PROCESSOR_LEVEL=15<br>
PROCESSOR_REVISION=0207<br>
ProgramFiles=C:\Program Files<br>
PROMPT=$P$G<br>
SESSIONNAME=Console<br>
SystemDrive=C:<br>
SystemRoot=C:\WINNT<br>
TEMP=C:\DOCUME~1\geoazul\LOCALS~1\Temp<br>
TMP=C:\DOCUME~1\geoazul\LOCALS~1\Temp
<br>
TNS_ADMIN=D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN<br>
USERDOMAIN=DHCP-CORTES<br>
USERNAME=geoazul<br>
USERPROFILE=C:\Documents and Settings\geoazul<br>
windir=C:\WINNT<br>
<br>
<br>
and at last the error<br>
<br>
<br>
<b>Warning</b>: [MapServer Error]: msDrawMap(): Failed to draw layer
named 'Gerencia Oracle'. in <b>D:\ms4w\apps\exphp\htdocs\ctacont0.php</b>
on line <b>155</b><br>
<br>
<b>Warning</b>: [MapServer Error]: msOracleSpatialLayerOpen(): Cannot
create OCI Handlers. Connection failure. Check the connection string.
Error: . in <b>D:\ms4w\apps\exphp\htdocs\ctacont0.php</b> on line <b>155</b><br>
<br>
<b>Fatal error</b>: Call to a member function saveWebImage() on a
non-object in <b>D:\ms4w\apps\exphp\htdocs\ctacont0.php</b> on line <b>156</b><br>
<br>
I have proved whit other programs and the db is totaly accesible.<br>
<br clear="all">
I don't know what to do I hope some one can help me.<br>
<br>
Thanks.<br>
-- <br>
Salu2!.<br>
<br>
Daniel Muñoz Castro<br>
Ingeniero Catastral y Geodesta<br>
Cel. 300 2174698<br>
Casa. 4095990<br>
Oficina. 7470001 Ext. 1141
</blockquote>
<br>
</body>
</html>