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

[zach cruise]

btw i got oracle 10 client (with tnsnames.ora) on 4.8 box. other than
returning multiple ora-xxxx errors, 4.8 also returns "web template
error" if i use /ignored-libmap/oracle10g/libmap.dll. this error is
even for only shapefile maps. error goes away when i switch back to
normal libmap.dll.

On Mon, Nov 17, 2008 at 5:56 PM, zach cruise <zachc1980 at gmail.com> wrote:
> 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
>>
>