According to this http://code.google.com/p/isapi-wsgi/wiki/ISAPISimpleHandlerDocs
the iis-wsgi adapter is single threaded. If this means what I think it means I would not use it. You can, instead use fastCGI which is provided by Microsoft http://www.iis.net/downloads/default.aspx?tabid=34&g=6&i=1521 web2py includes an adaptor and it is documented in AlterEgo MSSQL is the least tested database back-end and the weirdest of them all. It does not support pagination. we made it work in web2py with a trick but it is still slower and more inefficient than any other database backend. This will eventually be improved. Mind that this is not a web2py issue. mssql does not support pagination even if you use ASP.NET. Massimo On Feb 24, 9:42 pm, Paul Eden <benchl...@gmail.com> wrote: > I don't have any production experience yet with web2py under IIS but I > do know that it hypothetically runs because the cherrypy webserver > that web2py runs on is wsgi compatible and there is a wsgi adapter for > IIS (http://code.google.com/p/isapi-wsgi/). > > I have used MSSQL 2005 with python using the pymssql module and with > pyodbc both with great results. Pymssql is easier to setup, but uses > a deprecated MS C library for MSSQL. > > Paul > > > > On Tue, Feb 24, 2009 at 8:26 PM, Kirby Turner <ki...@thecave.com> wrote: > > > Hi All, > > > There is a possibility I can convince a customer of mind to switch > > from ASP.NET MVC to web2py. The catch? It must run under IIS 6 with > > SQL Server 2005. Are there others hosting production web2py apps > > under IIS 6 with MSSQL 2005? If so, how was the setup experience? > > Difficult, easy? Any unexpected gotcha? > > > I searched the mail group and read the other IIS related threads so my > > gut tells me there are not a lot of people using web2py with IIS. But > > maybe I'm wrong. > > > Thanks, > > -KIRBY > > -- > Best Regards, > > Paul Eden > > "...and a little looking out for the other guy too." > - Mr. Smith --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---