[Mapserver-users] oracle spatial mapfile

[Fernando S.]

Hi,
    How Nicolas suggest, the problem can be the permission to access 
this dll. Try to define the correct permission and execute your 
aplication again.

==================================================================
Fernando Simon - simon at cttmar.univali.br <mailto:simon at cttmar.univali.br>
==================================================================
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer
G10 - Laboratório de Computação Aplicada
http://g10.cttmar.univali.br
==================================================================


Sylvain Beorchia wrote:

>Hi,
>
>oci.dll is in C:\oracle\ora81\bin\
>With oracle spatial i want to draw some polygons, points and texts.
>
>----- Original Message ----- 
>From: "Fernando S." <simon at inf.univali.br>
>To: "Sylvain Beorchia" <sbeorchia at gi-lemans.fr>;
><mapserver-users at lists.gis.umn.edu>
>Sent: Monday, June 14, 2004 3:05 PM
>Subject: Re: [Mapserver-users] oracle spatial mapfile
>
>
>  
>
>>Hi Sylvain,
>>    Try to find in your system where are "oci.dll" (windows) or "oci.h"
>>(linux).
>>    And one more question, what do you want draw using
>>mapserv/oraclespatial?
>>
>>--------------------------------------------------------------------------
>>    
>>
>---------
>  
>
>>Fernando Simon
>>Data Base Manager, Mapserv and Oracle Spatial developer
>>G10 - Laboratorio de Computacao Aplicada
>>g10.cttmar.univali.br
>>--------------------------------------------------------------------------
>>    
>>
>----------
>  
>
>>Sylvain Beorchia wrote:
>>
>>    
>>
>>>RE: [Mapserver-users] oracle spatial mapfileHi, thanks.
>>>In fact my Mapserv.exe support Oracle. And i still got the error.
>>>What is exactly the oracle client dll ? i have Oracle 8.1.7 server
>>>      
>>>
>installed
>  
>
>>>on my pc.
>>>And do i have to include some SETENV var in my httpd.conf in Apache ? :
>>>
>>>   SetEnv ORACLE_SID spa
>>>   SetEnv ORACLE_BASE "c:/oracle"
>>>   SetEnv ORACLE_HOME "c:/oracle/ora81"
>>>   SetEnv ORA_NLS33 "c:/oracle/ora81/ocommon/nls/admin/data
>>>   SetEnv NLS_LANG "AMERICAN AMERICA"
>>>
>>>Thank u.
>>>
>>>----- Original Message ----- 
>>>From: Smith, Michael ERDC-CRREL-NH
>>>To: 'Sylvain Beorchia ' ; 'mapserver-users at lists.gis.umn.edu '
>>>Sent: Saturday, June 12, 2004 2:06 PM
>>>Subject: RE: [Mapserver-users] oracle spatial mapfile
>>>
>>>
>>>Sylvain,
>>>The error message indicates that Oracle Spatial support was not compiled
>>>      
>>>
>in
>  
>
>>>to mapserver. If you are using the unix/linux version you will need to
>>>add --with-oraclespatial=/path/to/oraclehome option to your configure
>>>command and re-make the build. If you are using Windows, there is a build
>>>including oraclespatial on the Mapserver download page but you'll need
>>>      
>>>
>the
>  
>
>>>oracle client dll's from otn.oracle.com .
>>>In either case, the data string is "geometry_column from table_name" so
>>>GEOLOC needs to be your geometry column. If you loaded your spatial data
>>>using OGR, the column is probably called ogr_geometry.
>>>Mike Smith
>>>ERDC/USACE
>>>michael.smith at erdc.usace.army.mil
>>>-----Original Message----- 
>>>From: Sylvain Beorchia
>>>To: mapserver-users at lists.gis.umn.edu
>>>Sent: 6/11/2004 5:52 AM
>>>Subject: [Mapserver-users] oracle spatial mapfile
>>>Hi list,
>>>I try to display some data from oracle spatial in my mapserver project.
>>>It
>>>doesn't work.
>>>Here is my mapfile layer:
>>>LAYER
>>>   NAME spa
>>>   METADATA
>>>       "DESCRIPTION" "Spatial"
>>>       "LEGENDE" "1"
>>>       "TYPE_LAYER" "ORA"
>>>   END
>>>   STATUS ON
>>>   CONNECTIONTYPE oraclespatial
>>>   CONNECTION "spa/sig at spa"
>>>   DATA "GEOLOC from FP10010_LINES"
>>>   TYPE LINE
>>>   CLASS
>>>       OUTLINECOLOR 0 0 0
>>>       COLOR 0 128 128
>>>   END
>>> END
>>>The data in the database are from some Mapinfo TabFiles. SO i've got a
>>>table
>>>FP10010_LINES with the GEOLOC field, that's why i've tried to retreive
>>>data
>>>with "GEOLOC from FP10010_LINES".
>>>So, when i launch my IE, i've got the following errors :
>>>   "Warning: MapServer Error in msOracleSpatialLayerOpen():
>>>OracleSpatial
>>>is not supported in C:\ms4w\apps\gmap\htdocs\gmap.php3 on line 616"
>>>   "Fatal error: Call to a member function on a non-object in
>>>C:\ms4w\apps\gmap\htdocs\gmap.php3 on line 617"
>>>
>>>
>>>My oracle version is 8i (8.1.7)
>>>Any ideas ?
>>>Thank u.
>>>_______________________________________________
>>>Mapserver-users mailing list
>>>Mapserver-users at lists.gis.umn.edu
>>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>>
>>>_______________________________________________
>>>Mapserver-users mailing list
>>>Mapserver-users at lists.gis.umn.edu
>>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>>
>>>
>>>
>>>      
>>>
>
>  
>