Hello I have this problem c:\web2py>python web2py.py -S ITAsset -M -P No handlers could be found for logger "web2py" web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2020 Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 Database drivers available: sqlite3, imaplib, pyodbc, pymysql, pg8000 Traceback (most recent call last): File "c:\web2py\gluon\restricted.py", line 227, in restricted exec ccode in environment File "applications\ITAsset\models\db.py", line 35, in <module> check_reserved=['all']) File "c:\web2py\gluon\packages\dal\pydal\base.py", line 174, in __call__ obj = super(MetaDAL, cls).__call__(*args, **kwargs) File "c:\web2py\gluon\packages\dal\pydal\base.py", line 473, in __init__ "Failure to connect, tried %d times:\n%s" % (attempts, tb) RuntimeError: Failure to connect, tried 5 times: Traceback (most recent call last): File "c:\web2py\gluon\packages\dal\pydal\base.py", line 446, in __init__ self._adapter = ADAPTERS[self._dbname](**kwargs) File "c:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 60, in __call__ obj = super(AdapterMeta, cls).__call__(*args, **kwargs) File "c:\web2py\gluon\packages\dal\pydal\adapters\mssql.py", line 159, in __init__ if do_connect: self.reconnect() File "c:\web2py\gluon\packages\dal\pydal\connection.py", line 125, in reconnect self.connection = f() File "c:\web2py\gluon\packages\dal\pydal\adapters\mssql.py", line 157, in connector return self.driver.connect(cnxn, **driver_args) File "C:\Python27\lib\site-packages\pypyodbc.py", line 2454, in __init__ self.connect(connectString, autocommit, ansi, timeout, unicode_results, readonly) File "C:\Python27\lib\site-packages\pypyodbc.py", line 2507, in connect check_success(self, ret) File "C:\Python27\lib\site-packages\pypyodbc.py", line 1009, in check_success ctrl_err(SQL_HANDLE_DBC, ODBC_obj.dbc_h, ret, ODBC_obj.ansi) File "C:\Python27\lib\site-packages\pypyodbc.py", line 987, in ctrl_err raise DatabaseError(state,err_text) DatabaseError: (u'08001', u'[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]Server SQL inesistente o accesso negato.')
My uri is uri = mssql4://sa:password@TS-SQL2016R2\SQLEXPRESS/itassetdb Do I have to install any ODBC SQL Server Driver on my client? In which way? I think I'm using pyodbc driver with python... Can you suggest me anything? Thanks so much -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/327092a7-e8b0-4dac-9da5-0a73e425841bo%40googlegroups.com.