[ms4w-users] MS4W fcgi with Oracle

[Jeff McKenna]

Michael Shishcu wrote:
> Hi, list.
> I wanted to set up mapserver (ms4w) to work in FastCGI mode with Oracle 
> database. Did everything as desribed in the readme_install guide and got 
> the same error (Apache logs: "mod_fcgid: get overlap result error").
> Later, looking deeper into the problem, found that mapserv.exe is 
> looking for a file OCI.DLL in all PATH directories, and if in does not 
> find it, it crashes, and apache server writes the known string into logs.
> So, the problem was resolved through adding the directory, containing 
> oci.dll (usualy ORACLE_HOME/BIN) into PATH of the fcgi module something 
> like this:
> <IfModule fcgid_module>
>     ....
>     DefaultInitEnv PATH        
> "c:/ms4w/Apache/cgi-bin;c:/WINDOWS/system32;c:/WINDOWS;c:/WINDOWS/System32/Wbem;c:/OracleClient/BIN"
>     ....
> </IfModule>
> 
> Now everything seems to work well :-)
> 
> hope this can be useful.
> regards,
> michael.
> 
>

Good advice Michael.  It would be great if you could do this testing 
with MS4W 3.0 beta3 and provide feedback (what worked, what did not) 
through the MS4W tracker 
(http://bugzilla.maptools.org/query.cgi?GoAheadAndLogIn=1).

thanks.

-jeff


-- 
Jeff McKenna
FOSS4G Consulting and Training Services
http://www.gatewaygeomatics.com/