AW: Mapserver+Windows+ArcSDE

[Mike Saunt]

shail

1.  remember to have the correct libmap.dll (from the shared/sde directory)
in the cgi-bin directory
2.  ensure that you have the ArcSDE C API Dll's loaded on the mapserver
machine
3.  run your mapfile with DEBUG=ON
4.  check you have the necessary permissions set for your connecting user to
the ArcSDE layers
5.  connection strings we use successfully are:
        CONNECTION "servername,port:portnum,database,username,password"
        CONNECTIONTYPE SDE
        DATA "schema.sdelayername,SHAPE,SDE.DEFAULT"

I'd suggest gettign a mapfile with a shape file as a base (so you know you
are in the correct area) and a single SDE layer to display over the top.

Also check the MapServer log file as this can tell you the errors (whether
permissions, server etc)

What is the message with (-1) ?

HTH
Mike


On 22/01/07, shail_79 at hotmail.com <shail_79 at hotmail.com> wrote:
>
> Hi Mike,
>
> I tried myself with SDE , SQL server and Mapserver to connect through
> Mapfile with ms4w package. I always gets an error (-1) for the SDE
> connection. I think   mapserver is able to connect through SDE, but it
> seems, the Data description within mapfile seems to be wrong.
>
> Do u have any document on how to establish the connection for SDE or How
> to define Data for SDE.
>
> I tried everything, whatever is instructed within ms4w readme file for
> SDE.
>
> But still i am getting an error.
>
> Your help would be highly appreciated.
>
> Thanks
>
> shail
>
> http://people.emich.edu/sgavathe
>
> Mike Saunt wrote:
> >
> > Hi
> >
> > We've successfully connected through to SDE (with the help of Howard)
> and
> > it
> > proves to be pretty simple.  I am very happy with taking MS4W,
> extracting
> > our required installation files and then applying the relevant
> > libmap.dll(from the sub directory) when on site and then changing the
> > connection
> > strings.  I'm very happy with this method as we don't need to recompile
> > (although we do for other reasons!)
> >
> > Regards
> > Mike
> >
> >
> > On 25/10/06, Pleyer, Walter <Walter.Pleyer at lfrz.at> wrote:
> >>
> >> Hi Howard!
> >>
> >> > you get these errors.  Are you trying to just render a layer?
> >> Yes, just simply rendering it is all we try to do.
> >> The backend DB is a Oracle 9.2.0.4 .
> >>
> >> > to build MapServer and all of its dependencies from scratch
> >> > on your platform of choice (Windows in your case).  The time
> >> > and misery required to do that is at least an order of
> >> > magnitude larger than peeling apart the .\bin and .\cgi-bin
> >> > directories plus the SDE libmap.dll from the MS4W package.
> >> I'm aware of that.
> >> That's why I hoped that someone might have done that already.
> >> But this is certainly the lesser problem and more a matter of
> >> convinience.
> >>
> >> Walter
> >>
> >
> >
> Quoted from:
> http://www.nabble.com/Mapserver%2BWindows%2BArcSDE-tf2502108.html#a6987646
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070122/dedd6439/attachment.html