Hello,
I have a production application that uses MS SQL Server in a UNIX
environment, running web2py version 1.99.4.
the connection is: dal > unixodbc > freetds > sqlserver.
I'm trying to migrate to web2py version 2.1.1, but fails to connect to the
database:
<type 'exceptions.RuntimeError'>(Failure to connect, tried 5 times:
Traceback (most recent call last): File
"/usr/home/jose/web2py/gluon/dal.py", line 6754, in __init__ self._adapter
= ADAPTERS[self._dbname](**kwargs) File
"/usr/home/jose/web2py/gluon/dal.py", line 3034, in __init__ if do_connect:
self.reconnect() File "/usr/home/jose/web2py/gluon/dal.py", line 582, in
reconnect self.connection = f() File "/usr/home/jose/web2py/gluon/dal.py",
line 3032, in connector return self.driver.connect(cnxn,**driver_args)
Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not
found, and no default driver specified (0) (SQLDriverConnectW)') )
the connection is:
db = DAL <http://127.0.0.1:8001/examples/global/vars/DAL>(
"mssql://CAPC;UID=user;PWD=pwd")
Any idea?
Thanks
Jose
--
