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
-~----------~----~----~----~------~----~------~--~---

Reply via email to