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

[Armin B. <arm...@gm...>]

Eric
if you have SDE on the same machine as Mapserver just add the dir with=20
sde91.dll to the system path. If not, you can run mapserv.exe and it=20
will tell you which dll is missing. Search that dll and copy it under a=20
dir in the system path (I usually create one for mapserver purposes).=20
Iteratively you should achieve to get all required dll's. Then try to=20
create a map with simple tools like shp2img.

Note that this question is no way related to p.mapper and on the=20
Mapserver mailing list you will for sure find better support for it.

armin

Eric Allard wrote:
> Thanks Armin!
>=20
> 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!
>=20
> Now I get this error when working with SDE 9.1 layer!
> I know it's not your software... :)=20
>=20
> ERROR:
> Warning: [MapServer Error]: msSDELayerOpen(): SE_connection_create():
> Operation Failed. (-1) in
> C:\p4_eric\projects\relocengine\projects\Akyem\main\carto\pmapper2\incp=
hp\in
> itgroups.php on line 229
>=20
> I checked my connection string... and it seems OK! I suspect the DATA
> string!
>=20
> I double check my SDE layer with ArcExplorer, and I can see it!
> SDE.DBO.ERIC
>=20
> Here's my Mapfile layer.
>=20
> ...
>   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
>=20
>=20
> QUESTIONS:
> The link you gave me,
> http://maptools.org/ms4w/index.phtml?page=3DREADME_INSTALL.html#sde-9-1
>=20
> 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)..
>=20
> -Q: Should I copy all those Dlls to a specific MS4W dir?
>=20
> I appreciate your time on this!
> -Eric
> =20
> -----Message d'origine-----
> De : Armin Burger [mailto:arm...@gm...]=20
> Envoy=E9 : 30 novembre 2006 16:54
> =C0 : Eric Allard
> Cc : pma...@li...
> Objet : Re: [pmapper-users] Mapscript connection to ArcSDE!
>=20
> You should try it with the latest ms4w version from maptools.org (you=20
> will need to change all your MS and PHP related libraries to be sure it=
=20
> 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
>=20
> armin
>=20
> 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\incp=
hp\in
>> itgroups.php on line 229
>> =20
>> 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=20
>>
>=20