try:
from gluon.dal import MSSQLAdapter
print MSSQLAdapter.driver
My guess isthat it is failing to import pyodbc from dal.py somehow and
the driver should should be set to
driver = globals().get('pyodbc',None)
is set to None instead.
On Oct 25, 10:20 am, CJM <coreymarq...@gmail.com> wrote:
> I'm unable to get web2py to connect to mssql.
>
> <type 'exceptions.RuntimeError'>(Failure to connect, tried 5 times:
> 'NoneType' object has no attribute 'connect')
>
> My connection string is: db = DAL('mssql://
> testUser:password1@localhost/testDB')
>
> Environment
> Windows Server 2008 R2, 64-bit operating system
> SQL Server 2008 R2, local.
> Web2py: source code install version 1.99.2 (2011-09-26 06:55:33)
> stable.
> pyodbc
> Python 2.7.2
>
> I've tested that I can connect using the pyodbc. The following code
> works:
>
> import pyodbc
> cnxn = pyodbc.connect('DRIVER={SQL
> Server};SERVER=localhost;DATABASE=testDB;UID=testUser;PWD=password1')
> cursor = cnxn.cursor()
> cursor.execute("select * from tbUsers")
> rows = cursor.fetchall()
> for row in rows:
> print row
>
> Thanks for your time.
>
> Corey.
