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

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

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