Please can anyone help me? thank you Il giorno venerdì 14 agosto 2020 alle 12:47:36 UTC+2 Andrea Fae' ha scritto:
> 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/c277bca4-f4dd-43a7-9155-9c271629ad0bn%40googlegroups.com.