Hi, I'm relatively new to web2py and am attempting to set up my production environment for the first time. I'm running Apache2.2 with mod_wsgi, python 2.7, & web2py 1.88.2 on Win XP SP3. If I run web2py without Apache by running: 'python web2py.py -a "<recycle>" -i 127.0.0.1 -p 8000' I can access both my application and the admin interface without any problems. Once I try to access my site running behind Apache though, I receive a ticket containing the following trackback:
Traceback (most recent call last): File "C:\web2py\gluon\restricted.py", line 188, in restricted exec ccode in environment File "C:/web2py/applications/lunch/models/db.py", line 11, in <module> db = DAL('mssql://lunch:lu...@b1ts003/lunch1') File "C:\web2py\gluon\sql.py", line 4048, in DAL raise RuntimeError, "%s (tried 5 times)" % exception RuntimeError: global name 'pyodbc' is not defined (tried 5 times) If I run web2py in terminal mode and import pyodbc I don't receive any errors: C:\web2py>python web2py.py -S welcome -P No handlers could be found for logger "web2py" web2py Enterprise Web Framework Created by Massimo Di Pierro, Copyright 2007-2010 Version 1.88.2 (2010-10-29 23:04:43) Database drivers available: SQLite3, MSSQL/DB2 Python 2.7 (r27:82525, Jul 4 2010, 09:01:59) [MSC v.1500 32 bit (Intel)] on win 32 Type "help", "copyright", "credits" or "license" for more information. (InteractiveConsole) >>> import pyodbc >>> I'm sure I'm probably just missing something in my confiration, but after scouring the web2py book and searching Google I haven't been able to find a solution. I'd greatly appreciate any suggestions, or if you need additional info, please let me know! Thanks, Adam