[MS4W-Users] Oracle support for Mapserver

[Jeff McKenna]

Hi Daniel,

Sorry for my delay, but I wanted to do more thorough testing before I 
responded.

I had no issues connecting to my Oracle 10g environment, with MS4W 3.2.1

However, I took the extra time to setup a whole new Oracle 12c 
environment, with data loaded into Oracle Spatial.  Again I had no 
issues connecting to MS4W 3.2.1 with Oracle 12c, but I did note the 
following:

- since the default MS4W package is 32bit, you/we must install the 32bit 
Oracle client, in order to allow MS4W (and MapServer and GDAL) to 
communication nicely with Oracle (even if the Oracle instance is x64). 
This is an important note (especially as the default installer for 
Oracle 12c is x64).  If you don't do this, then you will get an error 
such as "libmap.dll is not a valid 32bit application" when you run 
"mapserv -v" or "ogrinfo" (assuming you have already swapped the Oracle 
dlls, as noted in the MS4W instructions).

- in my case I found using the Oracle 32bit "Instant Client" the easiest 
to install (I used the "Instant Client Package - Basic" from 
http://www.oracle.com/technetwork/topics/winsoft-085727.html)

- I also found that setting both the ORACLE_HOME and TNS_ADMIN 
environment variables on my Windows machine, helped MS4W (MapServer and 
GDAL) communicate well with the Oracle instance

- I have updated the MS4W README with those notes for Oracle 
(http://ms4w.com/README_INSTALL.html#steps-to-enable-oracle-10g-or-11g-or-12c-support-in-ms4w)

If you still are stuck, you can contact me directly at any time for 
professional support, and we can discuss support rates.

I hope this more detailed response helps you.

Thanks for using MS4W.

-jeff


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



On 2017-02-16 6:10 AM, Daniel Hardes via MS4W-Users wrote:
> Hi, I have tried to get an Oracle connection with mapserver with oracle
> 12c.
>
> I used the guide on
> http://www.ms4w.com/README_INSTALL.html#c-mapserver-plugins but when I
> replace the libmap.dll with the one in the ignored-libmap/oracle12/ path
> and executing the setenv.bat, mapserv.exe -v doesn't even start anymore.
> I get a Windows application error with the application could not be
> started correctly. Is the DLL incompatible with the mapserver.exe or do
> I have to set some more oracle folders in the PATH Variable?
>
> What did I do wrong?
>
> I have a fresh ms4w installation with a running Oracle DB server.
>
>
> --
>
> 3DIS GmbH <http://www.3dis.de>
>
> 	
>
> Daniel Hardes
> Mail: hardes at 3dis.de <mailto:kalkofen at 3dis.de>| Tel.: +49 (0)2861 8919 84
>
> 3DIS GmbH
> Konrad-Zuse-Straße 6 D - 46397 Bocholt
> www.3dis.de <http://www.3dis.de>
>
> 3DIS GmbH | Geschäftsführung: Gerrit Hoven, Andreas Steffens |
> Amtsgericht Coesfeld | HRB 12986
>
>