With SDE on Oracle you can normally do that, so probably also with SDE/MSSQL. But you have to take care about the versioning function of SDE. I think that the direct access might not show the latest version of the table after editing. I guess newer releases of SDE (9+) could allow 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 might be a bit of a nightmare, from Windows it should work, either with direct access or via ODBC. In general, Mapserver via PHP/Mapscript is not blamingly fast to access SDE, SDE has a huge connection overhead. With MS CGI used as FastCGI 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, > > > > 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. > > > > We want to use Pmapper over MsSQL (ArcSDE) (Don’t 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) > > > > Thanks ALL for your time! > > I appreciate! > > -Eric Allard > > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
