Re: [pmapper-users] Mapscript connection to ArcSDE!

[Steffen M. <sdt...@gm...>]

Eric,

I got ArSDE working with MS4W 1.5.5. (2.* was not out when we did this. I a=
ssume
the same thing will work with 2.*)

The connection string was tricky and the ArcSDE messages were not really
helpful. Have a look at the connection string below.

Regards,

Steffen

layer
  CONNECTION "servername,esri_sde,sde,username,password"
  CONNECTIONTYPE SDE
  DATA "awc.awc_quera,shape"
  FILTER "WHERE SHAPE IS NOT NULL"
  type line
  status default
  class
    template "ttt_query.html"
    name "Basemap"
    color 170 170 170
  end
  maxscale 20000
  tolerance 1
  METADATA
    "DESCRIPTION" "Basemap"
    "RESULT_FIELDS" "AREA"
  END
end

On 12/2/06, Armin Burger <arm...@gm...> wrote:
> Eric
> if you have SDE on the same machine as Mapserver just add the dir with
> sde91.dll to the system path. If not, you can run mapserv.exe and it
> will tell you which dll is missing. Search that dll and copy it under a
> dir in the system path (I usually create one for mapserver purposes).
> Iteratively you should achieve to get all required dll's. Then try to
> create a map with simple tools like shp2img.
>
> Note that this question is no way related to p.mapper and on the
> Mapserver mailing list you will for sure find better support for it.
>
> armin
>
> Eric Allard wrote:
> > Thanks Armin!
> >
> > I installed my application on MS4W 2.2.1 running Pmapper 1.9.5. It seem=
s
> to
> > be working fine on PhpMapscript 4.10 and POSTGIS 8.0!
> >
> > Now I get this error when working with SDE 9.1 layer!
> > I know it's not your software... :)
> >
> > ERROR:
> > Warning: [MapServer Error]: msSDELayerOpen(): SE_connection_create():
> > Operation Failed. (-1) in
> >
> C:\p4_eric\projects\relocengine\projects\Akyem\main\carto\pmapper2\incphp=
\in
> > itgroups.php on line 229
> >
> > I checked my connection string... and it seems OK! I suspect the DATA
> > string!
> >
> > I double check my SDE layer with ArcExplorer, and I can see it!
> > SDE.DBO.ERIC
> >
> > Here's my Mapfile layer.
> >
> > ...
> >   LAYER
> >     NAME "MineInfra"
> >     TYPE POLYGON
> >     STATUS ON
> >     CONNECTION "localhost,port:5151,sde,sa,"
> >     CONNECTIONTYPE SDE
> >     DATA "SDE.DBO.ERIC,shape,"
> >     FILTER "where shape is not NULL"
> >     CLASS
> >       TEMPLATE void
> >       NAME "Phase 1"
> >       COLOR 150 185 255
> >       OUTLINECOLOR 110 110 110
> >     END
> >   END # LAYER
> >
> >
> > QUESTIONS:
> > The link you gave me,
> > http://maptools.org/ms4w/index.phtml?page=3DREADME_INSTALL.html#sde-9-1
> >
> > THEY SAY:
> >   1- Make sure the ArcSDE SDK dlls for 9.1 are available on your machin=
e
> > (the same machine that you are running MS4W on)..
> >
> > -Q: Should I copy all those Dlls to a specific MS4W dir?
> >
> > I appreciate your time on this!
> > -Eric
> >
> > -----Message d'origine-----
> > De : Armin Burger [mailto:arm...@gm...]
> > Envoy=E9 : 30 novembre 2006 16:54
> > =C0 : Eric Allard
> > Cc : pma...@li...
> > Objet : Re: [pmapper-users] Mapscript connection to ArcSDE!
> >
> > You should try it with the latest ms4w version from maptools.org (you
> > will need to change all your MS and PHP related libraries to be sure it
> > works, so MS 4.10 and PHP 5.2). Seems like they have support for SDE
> > =3D> http://maptools.org/ms4w/index.phtml?page=3DREADME_INSTALL.html#sd=
e-9-1
> >
> > armin
> >
> > Eric Allard wrote:
> >> Hi! All!
> >>
> >> After trying the following SDE layer connection, I get the following
> > error:
> >> Warning: [MapServer Error]: msSDELayerOpen(): SDE support is not
> > available.
> >> in
> >>
> >
> C:\p4_eric\projects\relocengine\projects\Akyem\main\carto\pmapper2\incphp=
\in
> >> itgroups.php on line 229
> >>
> >> My setup:
> >> -Windows XP
> >> -MSSQL 2000
> >> -ArcSDE 9.1 (As a service)
> >> -Apache 2.0.X
> >> -PHP 5.0.5
> >> -Pmapper 1.9.5
> >> -php_mapscript_46.dll (Loaded at PHP start)
> >>
> >> My Mapfile connection:
> >>     CONNECTION "localhost,port:5151,sde,sa,'',"
> >>     CONNECTIONTYPE SDE
> >>     DATA "SDE.DBO.ERIC,LAYER,SDE.DEFAULT"
> >>
> >> Question:
> >> 1. How do I link the phpmapscrip.dll to use sde91.dll (Or other needed
> > srv)?
> >>
> >> Link to the phpmapscrip46 used:
> >> - Binary Packages - Win32
> >> - mapserver-4.6.1-win32-php5.0.5.zip ~16 MB
> >> http://www.maptools.org/php_mapscript/index.phtml?page=3Ddownloads.htm=
l
> >>
> >> Thanks!
> >> -Eric
> >>
> >
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share y=
our
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> pmapper-users mailing list
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>