Yep, I'm still using the apache comming with Uniform Server. http://ochiba77.blogspot.com/2011/10/how-to-setup-web2py-apache-wsgi-uniform.html
I'm successfully connecting both SQL Server 2008 and DB2. On Friday, May 25, 2012 12:08:59 AM UTC-5, Andrew wrote: > > Oh, Just found this post, which was linked in Omi Chiba's original Blog > post: > https://groups.google.com/forum/?fromgroups#!topic/web2py/EM5Q3yOz63M > > From dlypka: > The root cause is that the Distribution Windows Build of Apache 2.2 is > built with msvcr71.dll which is the C++ runtime dll > for Visual Studio 2003!!! But, most recent builds of python .pyd files > which link to C/C++ code, are built with msvcr90.dll which is the one > from Visual Studio 2008. > > Summary: There is an issue running pyodbc with apache2.2 on Windows. > Solution: Build Apache yourself with Visual Studio 2008, or use IIS. > > Oh well. > > > On Friday, May 25, 2012 4:54:23 PM UTC+12, Andrew wrote: >> >> It is installed and the app has been working fine with the Rocket http >> server. It's just the apache one that doesn't. Unless I need to install >> it again in the apache context ? >> >> On Friday, May 25, 2012 4:05:27 PM UTC+12, Massimo Di Pierro wrote: >>> >>> You need to install pyodbc >>> >>> On Thursday, 24 May 2012 19:41:21 UTC-5, Andrew wrote: >>>> >>>> Hello, >>>> I'm in the process of running web2py on Apache for the first time. I >>>> found some excellent tutorials on this, such as: >>>> http://ochiba77.blogspot.co.nz/2011/10/how-to-setup-web2py-apache-wsgi.html, >>>> >>>> and also Martin Mulone's Blog site. Thanks for sharing the knowledge >>>> (BTW, >>>> I think it makes sense to include this in the book - Deployment recipes). >>>> >>>> With a minimal amount of fuss I was able to get the Welcome app to come >>>> up. I then pointed to an existing app that connects to a SQL Server >>>> database, and I get the error: >>>> File "E:\TWLApps\web2py\gluon\dal.py", line 2600, in __init__ >>>> raise RuntimeError, "Unable to import driver" >>>> RuntimeError: Unable to import driver >>>> >>>> *I stopped Apache and started the normal "python web2py.py ...." and >>>> my MSSQL app works fine !* >>>> >>>> So, something with my apache config is stopping web2py finding, or >>>> loading the (pyodbc?) driver - I think !. >>>> I've searched the forum and web but I haven't found this particular >>>> issue. Any pointers would be appreciated. >>>> >>>> Thanks >>>> Andrew W >>>> >>>
