It seens someone are having same issue woth Pyodbc and sqlalchemy http://stackoverflow.com/questions/4665078/connect-to-mssql-from-sqlalchemy-by-pyodbc-on-mac-os
So it is not web2py DAL issue, it is Pyodbc issue, anyone aware? On Tue, Mar 29, 2011 at 12:28 PM, Bruno Rocha <[email protected]> wrote: > HI, > > I am trying connection to MSSQL using standalone DAL, but I am getting this > error: > > Traceback (most recent call last): > File "baixar_arquivos.py", line 10, in <module> > db = DAL('mssql://user1:[email protected]/coelba') > File "/Users/rochacbruno/Dropbox/gente/web2py/gluon/dal.py", line 3665, > in __init__ > raise RuntimeError, "Failure to connect, tried 5 times:\n%s" % error > RuntimeError: Failure to connect, tried 5 times: > ('00000', '[00000] [iODBC][Driver Manager]dlopen({SQL Server}, 6): image > not found (0) (SQLDriverConnectW)') > > > I installed pyodbc on MacOS X, I dont know how to deal with this error > message. > > -- > Bruno Rocha > [ About me: http://zerp.ly/rochacbruno ] > >
