Brian, Thank you for the info ! I also added the information on my blog.
On Friday, May 25, 2012 7:32:23 PM UTC-5, Brian M wrote: > > Yep, got burned by this when setting up a new server last month. The > problem is covered in the pyodbc issue tracker here - > http://code.google.com/p/pyodbc/issues/detail?id=126 I ended up grabbing > a build from http://www.apachelounge.com/download/additional/ and then > all was good. > > 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 >>>>> >>>>
