Eric,
I got ArSDE working with MS4W 1.5.5. (2.* was not out when we did this. I assume
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 <[EMAIL PROTECTED]> 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 seems
> 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=README_INSTALL.html#sde-9-1
> >
> > THEY SAY:
> > 1- Make sure the ArcSDE SDK dlls for 9.1 are available on your machine
> > (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:[EMAIL PROTECTED]
> > Envoyé : 30 novembre 2006 16:54
> > À : Eric Allard
> > Cc : [email protected]
> > 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
> > => http://maptools.org/ms4w/index.phtml?page=README_INSTALL.html#sde-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=downloads.html
> >>
> >> 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 your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> pmapper-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
