[Mapserver-users] oracle spatial mapfile

[Fortin,Nicolas [SteFoy]]

I don't know about apache...

Oracle client dll is oci.dll.  You should give access to the oracle folder to the internet anonymus user, it a commun mistake.  You can easily find permission issue with filemon.exe

Nicolas


-----Message d'origine-----
De : mapserver-users-admin at lists.gis.umn.edu [mailto:mapserver-users-admin at lists.gis.umn.edu] De la part de Sylvain Beorchia
Envoyé : Monday, June 14, 2004 7:47 AM
À : Smith, Michael ERDC-CRREL-NH; mapserver-users at lists.gis.umn.edu
Objet : Re: [Mapserver-users] oracle spatial mapfile


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