shail<br><br>1. remember to have the correct libmap.dll (from the shared/sde directory) in the cgi-bin directory<br>2. ensure that you have the ArcSDE C API Dll's loaded on the mapserver machine<br>3. run your mapfile with DEBUG=ON
<br>4. check you have the necessary permissions set for your connecting user to the ArcSDE layers<br>5. connection strings we use successfully are:<br> CONNECTION "servername,port:portnum,database,username,password"
<br> CONNECTIONTYPE SDE <br> DATA "schema.sdelayername,SHAPE,SDE.DEFAULT" <br><br>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.
<br><br>Also check the MapServer log file as this can tell you the errors (whether permissions, server etc)<br><br>What is the message with (-1) ?<br><br>HTH<br>Mike<br><br><br><div><span class="gmail_quote">On 22/01/07,
<b class="gmail_sendername"><a href="mailto:shail_79@hotmail.com">shail_79@hotmail.com</a></b> <<a href="mailto:shail_79@hotmail.com">shail_79@hotmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Mike,<br><br>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.
<br><br>Do u have any document on how to establish the connection for SDE or How to define Data for SDE.<br><br>I tried everything, whatever is instructed within ms4w readme file for SDE.<br><br>But still i am getting an error.
<br><br>Your help would be highly appreciated.<br><br>Thanks<br><br>shail<br><br><a href="http://people.emich.edu/sgavathe">http://people.emich.edu/sgavathe</a><br><br>Mike Saunt wrote:<br>><br>> Hi<br>><br>> We've successfully connected through to SDE (with the help of Howard) and
<br>> it<br>> proves to be pretty simple. I am very happy with taking MS4W, extracting<br>> our required installation files and then applying the relevant<br>> libmap.dll(from the sub directory) when on site and then changing the
<br>> connection<br>> strings. I'm very happy with this method as we don't need to recompile<br>> (although we do for other reasons!)<br>><br>> Regards<br>> Mike<br>><br>><br>> On 25/10/06, Pleyer, Walter <
<a href="mailto:Walter.Pleyer@lfrz.at">Walter.Pleyer@lfrz.at</a>> wrote:<br>>><br>>> Hi Howard!<br>>><br>>> > you get these errors. Are you trying to just render a layer?<br>>> Yes, just simply rendering it is all we try to do.
<br>>> The backend DB is a Oracle <a href="http://9.2.0.4">9.2.0.4</a> .<br>>><br>>> > to build MapServer and all of its dependencies from scratch<br>>> > on your platform of choice (Windows in your case). The time
<br>>> > and misery required to do that is at least an order of<br>>> > magnitude larger than peeling apart the .\bin and .\cgi-bin<br>>> > directories plus the SDE libmap.dll from the MS4W package.
<br>>> I'm aware of that.<br>>> That's why I hoped that someone might have done that already.<br>>> But this is certainly the lesser problem and more a matter of<br>>> convinience.<br>>>
<br>>> Walter<br>>><br>><br>><br>Quoted from:<br><a href="http://www.nabble.com/Mapserver%2BWindows%2BArcSDE-tf2502108.html#a6987646">http://www.nabble.com/Mapserver%2BWindows%2BArcSDE-tf2502108.html#a6987646
</a><br><br></blockquote></div><br>