ArcSDE, FastCGI+IIS

[Mike Saunt]

Hi Shannon

You've caught me out here as I hadn't finished the documentation as in the
end we didn't use direct access to ArcSDE!

The problem was with the FastCGI dropping out quite alot and therefore the
CGI execution would fail intermitently.  The other problems was also to do
with licensing for ArcSDE (i.e. ArcSDE client access libary costs) and also
the fact that upgrades to ArcSDE aren't always instantaneous i.e. can take
the whole internet mapping down whilst the DB is ugraded over a few days.

In the end we implemented some caching with OGR tools to basically download
at regular intervals (every 15 minutes via Windows Scheduled tasks) to
shapefiles.  This has proven effective and very resiliant as our scripts
detect a failure if the ArcSDE database isn't available and leaves the
previous cached shapefile therefore the internet site doesn't do down.

I'd be interested to look at using FASTCGI with ArcSDE again but at present
don't have a business need as the above works really well.

Let me know if you still want the documentation and I'll send over...

Kind Regards
Mike


On 05/04/07, X Sun <xijiang.sun at saic.com> wrote:
>
> Hi   Mike Saunt and/or  Howard,
>
> I found out the post and knew that Mike had already done a great job
> making
> FastCGI + IIS + SDE works.
>
> Do we have already had a documented procedure to set up  FastCGI + IIS?
>
> I did not find it from the web site.   Could you pass me a copy of
> document
> if there is one already?  I am now frustrating reading document here and
> there to see how to make them works together
>
> My email is sunx at saic.com
>
> Thanks a lot.
>
> Shannon Sun
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070410/d366f327/attachment.html