Thread: [pmapper-users] PHP connection to ArcSDE!
Brought to you by:
arminburger
Menu
▾
▴
pmapper-users
|
From: Eric A. <eri...@bo...> - 2006-11-07 16:49:07
|
Hi all, =20 I know this is a Pmapper list, but since Pmapper is on the PHP side and = uses Mapserver (via PhpMapscript) I thought maybe someone already went = through the same type of setup. =20 We want to use Pmapper over MsSQL (ArcSDE) (Don=92t ask me Why?... I = know!) I know PhpMapscript is supporting ArcSDE, but my questions are: - Can we use adodb-mssql driver to access an ArcSDE database for the NON related spatial information? - If not, how can I make a connection from the PHP code to the ArcSDE database. (Without coding a C API) =20 Thanks ALL for your time! I appreciate! -Eric Allard --=20 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.13.25/515 - Release Date: = 11/3/2006 =20 |
|
From: Armin B. <arm...@gm...> - 2006-11-07 17:16:57
|
With SDE on Oracle you can normally do that, so probably also with=20 SDE/MSSQL. But you have to take care about the versioning function of=20 SDE. I think that the direct access might not show the latest version of=20 the table after editing. I guess newer releases of SDE (9+) could allow=20 to disable the versioning, but it's years ago that I used SDE... If you are accessing the MS SQLServer from Linux then the configuration=20 might be a bit of a nightmare, from Windows it should work, either with=20 direct access or via ODBC. In general, Mapserver via PHP/Mapscript is not blamingly fast to access=20 SDE, SDE has a huge connection overhead. With MS CGI used as FastCGI=20 this might be better if it can hold the connection. But I guess on the Mapserver list you will find better suggestions. armin Eric Allard wrote: > Hi all, >=20 > =20 >=20 > I know this is a Pmapper list, but since Pmapper is on the PHP side and= uses > Mapserver (via PhpMapscript) I thought maybe someone already went throu= gh > the same type of setup. >=20 > =20 >=20 > We want to use Pmapper over MsSQL (ArcSDE) (Don=92t ask me Why?... I kn= ow!) >=20 > I know PhpMapscript is supporting ArcSDE, but my questions are: >=20 > - Can we use adodb-mssql driver to access an ArcSDE database for the NO= N > related spatial information? >=20 > - If not, how can I make a connection from the PHP code to the ArcSDE > database. (Without coding a C API) >=20 > =20 >=20 > Thanks ALL for your time! >=20 > I appreciate! >=20 > -Eric Allard >=20 >=20 |
|
From: Eric A. <eri...@bo...> - 2006-11-30 21:11:27
|
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
--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.13/546 - Release Date: 2006-11-22
|
|
From: Armin B. <arm...@gm...> - 2006-11-30 21:53:53
|
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 > |
|
From: Eric A. <eri...@bo...> - 2006-12-01 21:48:11
|
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... :)=20
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 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
=20
-----Message d'origine-----
De=A0: Armin Burger [mailto:arm...@gm...]=20
Envoy=E9=A0: 30 novembre 2006 16:54
=C0=A0: Eric Allard
Cc=A0: pma...@li...
Objet=A0: Re: [pmapper-users] Mapscript connection to ArcSDE!
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#sde-9-1
armin
Eric Allard wrote:
> Hi! All!
>=20
> After trying the following SDE layer connection, I get the following
error:
>=20
> 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
> =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)
>=20
> My Mapfile connection:
> CONNECTION "localhost,port:5151,sde,sa,'',"
> CONNECTIONTYPE SDE
> DATA "SDE.DBO.ERIC,LAYER,SDE.DEFAULT"
>=20
> Question:
> 1. How do I link the phpmapscrip.dll to use sde91.dll (Or other needed
srv)?
>=20
>=20
> 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.html
>=20
> Thanks!
> -Eric=20
>=20
--=20
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.13/546 - Release Date: =
2006-11-22
=20
--=20
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.13/546 - Release Date: =
2006-11-22
=20
|
|
From: Armin B. <arm...@gm...> - 2006-12-02 13:30:47
|
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 |
|
From: Steffen M. <sdt...@gm...> - 2006-12-03 06:24:55
|
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
>
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X