[MS4W-Users] SDE

[Yves Moisan]

Hi Brent,

Thanx for your detailed instructions !  Luckily, all I care about for
that particular project is vector data, so it should be easier.

Thanx again !

Yves

> 
> 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 
> detective work.
> 
> The steps:
> ----------
> 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:
> ------------------------------
> LAYER
>    ...
>    CONNECTIONTYPE PLUGIN
>    CONNECTION "server,port:5151,sde,username,password"
>    PLUGIN "C:/ms4w/Apache/specialplugins/msplugin_sde_92.dll"
>    DATA "GIS.SDE.mylayer,SHAPE,SDE.DEFAULT"
>    ...
> 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 
> http://www.mail-archive.com/mapserver-users@lists.osgeo.org/msg03049.html
> ------------------------------
> LAYER
>    NAME         hillshade
>    STATUS       DEFAULT
>    TYPE         RASTER
>    CONNECTION "server,port:5151,sde,username,password"
>    CONNECTIONTYPE PLUGIN
>    PLUGIN "c:/ms4w/apache/specialplugins/msplugin_sde_92.dll"
>    DATA "SDE:server,5151,sde,username,password,SCHEMA.RASTERLAYER,RASTER"
>    PROJECTION
>      "+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"
>    END
> END
> ------------------------------
> 
> 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...
> 
> Best Regards,
> Brent Fraser
> 
> 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 [1] and
> > CONNECTIONTYPE PLUGIN [2] are handled ?  Any difference in performance,
> > ease of use, etc ?
> > 
> > TIA,
> > 
> > Yves
> > 
> > [1] http://mapserver.org/input/vector/arcsde.html
> > [2] http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html
> > 
> > _______________________________________________
> > MS4W-Users mailing list
> > MS4W-Users at lists.maptools.org
> > http://lists.maptools.org/mailman/listinfo/ms4w-users
> >