[ms4w-users] ArcSDE connection

[János Gonzales]

Hey Jeff,

I figured out the problem I was having with connecting to sde and
seeing the output over a browser connection.   I just moved all the
SDE dlls into the apache cgi-directory and then the browser request
worked as well.   These dlls are pe91.dll,  sde91.dll,  and sg91.dll.
   The path to sde installation does not have to be in the
environmental variables if you do this.

I'm getting myself a beer now.



On 3/16/07, János Gonzales <janos.gonzales at gmail.com> wrote:
> Hi Jeff,
>
> I have "C:\ArcGIS\ArcSDE\bin"  in my system path and I seem to be
> making the connection to SDE.
>
> When I run mapserver through the command line, like so:
> mapserv.exe QUERY_STRING="map=test.map&layer=sdelayer ..."
> I get the output that would normally go into an html page. If I check
> the output directory I see that the image created from the SDE layer
> is there.
>
> However, when trying to access mapserver via a url with the same query
> string, I get a "500 internal server error"
>
> At this point I don't get any error messages in the mapserver error
> log, and the Apache error log just reports "Premature end of script
> headers".
>
> If I replace the libmap.dll  with its non-sde version then I do not
> get the server error.
>
> I'm really not sure what else I'm missing.
>
> Thanks,
> Janos
>
>
>
> On 3/16/07, Jeff McKenna <jmckenna at dmsolutions.ca> wrote:
> > Make sure the sde9.1 client dlls are in your path, follow the
> > instructions that you mentioned, and you should be able to connect to
> > SDE with MS4W 2.2.3.
> >
> > jeff
> >
> >
> >
> >
> > Janos Gonzales wrote:
> > > Hello,
> > >
> > > Just downloaded  ms4w_2.2.3.zip    from
> > > http://www.maptools.org/ms4w/index.phtml?page=downloads.html
> > >
> > > I am trying to connect UMN Mapserver to an oracle table through ArcSDE.
> > >
> > > At this point in my mapfile I have one shapefile, one connection to
> > > oracle, and one connection to arcsde.
> > >
> > > When I replace the libmap.dll with the libmap.dll from Oracle  things
> > > seem to work fine.
> > >
> > > But, when I replace libmap.dll with the libmap.dll from the ignored
> > > directory in sde9.1,   mapserver throws an 'internal server error'
> > > which in the error.log shows up as  "Premature end of script headers"
> > >
> > > I followed the instructions on
> > > http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#sde-9-1
> > >
> > > I am running Apache and arcsde 9.1  .
> > >
> > > Is there something wrong with the sde91  libmap.dll file?
> > >
> > >
> > >
> > >
> > > Thanks,
> > > János
> > >
> >
> >
> >
> > --
> > Jeff McKenna
> > DM Solutions Group Inc.
> > http://www.dmsolutions.ca
> > _______________________________________________
> > ms4w-users mailing list
> > ms4w-users at lists.maptools.org
> > http://lists.maptools.org/mailman/listinfo/ms4w-users
> >
>