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