oracle spatial

[Daniel Goetz]

Hi,

I have a question concernig the visualisation of oracle spatial data via umn-mapserver.

I have installed the recent ms4w package on my computer. (c:\ms4w). I installed the oracle client (9i Release 2 Version) on drive d:\. The real database lies on an server in the intranet (not internet).

I read in the "Using Oracle Spatial Data with MapServer"-howto: "Make sure though your Mapserver is compiled against the same version as your Oracle client". My question is how can I check this?

I also read that when using oracle spatial data via the native support (without OGR) no FeatureInfo Requests are supported. Is this true?

Despite of that I want to try the native support of oracle spatial data. In the "Using Oracle Spatial Data with MapServer"-howto I read, that I have to do some environmental settings in the Apache httpd.conf file. Is there a more precise despriction how to do that?

In the "vector data access" reference I read that "OGR must be compiled with Oracle Spatial support and MapServer must be compiled to use OGR". According to my understandig in the ms4w package OGR is compiled with oracle spatial support and mapserver should also be compiled to use OGR in the ms4w package. Am I right?

To map the data via OGR-interface I simply wrote the follwoing in my .map-file:

LAYER
        NAME "RWG_TBL"
        CONNECTIONTYPE OGR
        CONNECTION "OCI:gds_brwk2004_umn/umn at gds1prod"
        DATA "RWG_TBL"
        TYPE POINT
        STATUS ON
        CLASS
            NAME "Flaeche"
            STYLE
                 OUTLINECOLOR 128 128 128
                 COLOR 225 225 185
            END
        END
END

Is this all? Did I forget anything in the file itself? Or do I have to make any furhter settings? However, when I test it (I use the following command in my brwoser: http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/Apache/htdocs/raster/test_or.map&layers=all&) mapserver tells me: 

"msDrawMap(): Image handling error. Failed to draw layer named 'RWG_TBL'.
msOGRFileOpen(): OGR error. Open failed for OGR connection `OCI:gds_brwk2004_umn/umn at gds1prod'. File not found or unsupported format."

What went wrong? Mapping shapefieles or .tif is no problem. Might it be possible that I have installed the oracle-client on the wrogn locations?


Many questions I can not answer by myself. It's really difficult for me. Would be very nice if anybody could help me. I would be very glad and thankful. Thank you very much.


Regards

Daniel Goetz
-- 


Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer