Ross,
Yes, I can connect from console and web2py under rocket. It only fails to connect under wsgi on Apache. There are some post says it happens because it fails (cannot find) to "import pyodbc" and we can change Apache config to recognize the path just like environment setting on windows pc.... but I'm not sure.
