bfraser at geoanalytic.com
Wed Jan 20 12:34:35 EST 2010
I spent a couple of days trying to get MS4W/Mapserver to read vector and raster
data from SDE 9.3
The good news is that it can be done. The bad news is that it's not easy.
Displaying vectors wasn't too bad, but getting the rasters to display took some
1. Use MS4W 3.0 Beta 7 (or better when available). The gdal_SDE.dll and
ogr_SDE.dll are compiled with a gdal17DEV.dll shipped in MS4W (in MS4W v2.3.1
they are compiled with gdal15.dll and won't work with MS4W 2.3.1). I copied the
gdalplugins dir (with gdal_SDE.dll and ogr_SDE.dll) to be under cgi-bin.
2. Since the MS4W 3.0 Beta 7 is a zip style install, you'll need to set paths to
ensure Apache and mapserver can find msvcr90.dll and msvcp90.dll (they're in the
apache\cgi-bin dir I think).
3. The vector connection for SDE 9.3 looked like the one in the MS4W doc:
END # layer
I never did the CONNECTIONTYPE SDE to compare performance, but I'd be interested
in what you find out!
4. The raster connection looked like the one in
"+proj=lcc +lat_1=49 +lat_0=49 +lon_0=-95 +k_0=1 +x_0=0 +y_0=0 +ellps=GRS80
+datum=NAD83 +units=m +no_defs"
That email message is the only doc I could find showing how to make connection
work. And don't you dare put any spaces between the commas in the DATA statement.
I also had a problem with apache and a local firewall. The SDE raster would
display with shp2img and running mapserv.exe interactively on the command line,
but not as a CGI program thru apache. So I installed IIS and things worked. I
expect a little tweaking of the apache conf file would have worked as well but I
ran out of time...
Yves Moisan wrote:
> Hi All,
> We have to connect to an ArcSDE 9.3.1 and I noticed that the MS4W we
> have in place (2.3.1) has specialplugins dlls for 9.1 and 9.2. I was
> wondering if I could just use the specialplugins dll for 9.3 that ships
> with MS4W 3.0.0B7 in my 2.3.1 or are the dlls dependent on the MapServer
> version ? Or am I good to go because the dll relies on code old enough
> in MS that hasn't changed between 5.2.1 and whatever MS is shipped with
> MS4W ?
> Also, I'd like to know what the best practice is for SDE in the mapfile.
> What is the difference between how CONNECTIONTYPE SDE  and
> CONNECTIONTYPE PLUGIN  are handled ? Any difference in performance,
> ease of use, etc ?
>  http://mapserver.org/input/vector/arcsde.html
>  http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html
> MS4W-Users mailing list
> MS4W-Users at lists.maptools.org
More information about the MS4W-Users