oracle spatial

[Rahkonen Jukka]

Hi,

MS4W 1.5.3 with native Oracle support is totally functional with different file formats. I have in a same mapfile layers from local GeoTIFF and JPEG 2000 images, external rasters through WMS service, local shapefiles, polygons from Oracle spatial and external vectors through WFS service and they work just fine, all together.

I wonder why you get problems with other that Oracle spatial layers after changing the libmap.dll and activating the ogr_OCI.dll. They should have no effect on those layers, but if they do then I believe it is no use to struggle with other things before that problem is solved.

-Jukka-


-----Alkuperäinen viesti-----
Lähettäjä: Daniel Goetz [mailto:madprof at gmx.ch] 
Lähetetty: 14. kesäkuuta 2006 14:02
Vastaanottaja: Rahkonen Jukka; MAPSERVER-USERS at LISTS.UMN.EDU
Aihe: Re: Re: [UMN_MAPSERVER-USERS] oracle spatial

Hi Jukka,

thank you again for your help. You think it should be possible to map differnt file-formats (shapefiles, oracle spatial, raster-data, etc.) at the same time even if you have changed the .dll files for orcale support?

The suggestions you made in your e-mail, that I should test a new, "untouched" installation of ms4w on another computer, i have already tested. I installed ms4w, tested some shapfiles and raster data and they worked. then I did the .dll swapping and neither the oracledata nor other file-formats work. I always get an apache-error-message. except for I point to a table that does not exist in the database in the DATA-experssion of the mapfile. then I get the mapserver-error-message you mentioned in your last email. 

And yes, I testes the unsuccessful SQL (correcting the consciously wrong tablename_experssion) and it workes fine. Perhaps you can email me your mapfile, in which you point to an oracle spatial database. Perhaps I do a mistake in the mypfile. Would be very nice. Thank you for your endeavor and your time and your help.

regards


.......

SNIP