oracle spatial

[Bart van den Eijnden (OSGIS)]

Daniel,

the MS4W package should state against which Oracle version the binaries
were compiled, there is no way to find this out otherwise AFAIK.

FeatureInfo is supported on the native Oracle Spatial driver since
Mapserver 4.6 IIRC.

To use Oracle with MS4W you need to replace some of the dll's etc. in
MS4W, did you do that?

The most important thing is that the oci.dll from your Oracle client is in
the Windows path.

I assume you already checked if you can connect using sqlplus?

Best regards,
Bart

> 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
>