[mapserver-users] ms4w (fastcgi) and oracle 10?

[zach cruise]

looks like mod_fastcgi is not an option with ms4w and oracle 10.
anyway it had little benefits.

i now got mapserver 5.2 and 4.8:
i thought 5.2 had native built-in support for oracle 10, but it is
giving me "OracleSpatial is not supported" error. i also thought 4.8
could get ogr support for oracle 10 by following the steps on
http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g.
4.8 connects, but returns multiple ORA-xxxx errors.

so:
do i have to install oracle 10 client locally and make changes to
httpd.conf for 5.2 to work?
how do i find correct srid for 4.8 to work? (DATA "GEOMETRY from
(select GEOMETRY from STATES where NAME = 'New York')")
any performance difference between native built-in and ogr supports?

On Fri, Nov 14, 2008 at 6:22 PM, Jeff McKenna
<jmckenna at gatewaygeomatics.com> wrote:
> zach cruise wrote:
>>
>> does current ms4w with fastcgi work with oracle 10?
>>
>> here're warnings
>> http://www.maptools.org/ms4w/?page=README_INSTALL.html#f-fastcgi
>>
>> http://www.nabble.com/fastcgi-connections-to-Oracle-and-SDE-on-Windows-to18394152.html
>> in testing this was successful with PostgreSQL 8.3.1 / PostGIS 1.3.3,
>> but unsuccessful with Oracle 10.2.0.1.0 (Apache logs: "mod_fcgid: get
>> overlap result error")
>>
>> if not, any workarounds?
>
> I tested and wrote that note...and am not aware of a workaround yet. You
> should also send this question to the MS4W mailing list (subscribe at:
> http://lists.maptools.org/mailman/listinfo/ms4w-users)
>
>
> --
> Jeff McKenna
> FOSS4G Consulting and Training Services
> http://www.gatewaygeomatics.com/
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>