Hello, I tried and I set in the appconfig.ini this URI uri = mssql4://sa:password@TS-SQL2016R2\SQLEXPRESS/itassetdb
TS-SQL2016R2 is the hostname SQLEXPRESS is the instance itassetdb is the db created empty when I try to execute this command 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 34, 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:\web2py\gluon\contrib\pypyodbc.py", line 2434, in __init__ self.connect(connectString, autocommit, ansi, timeout, unicode_results, readonly) File "c:\web2py\gluon\contrib\pypyodbc.py", line 2483, in connect check_success(self, ret) File "c:\web2py\gluon\contrib\pypyodbc.py", line 988, in check_success ctrl_err(SQL_HANDLE_DBC, ODBC_obj.dbc_h, ret, ODBC_obj.ansi) File "c:\web2py\gluon\contrib\pypyodbc.py", line 966, 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.') I have the error regarding Server SLQ non existent or access denied? What can I do? thank you Il giorno mercoledì 12 agosto 2020 17:17:17 UTC+2, villas ha scritto: > > Here are some notes which you may find helpful... > > The basic idea is this: > > - Create a new DB using your preferred MSSQL management tool. > - Change your DAL connection string and run the app. > - Check that the new DB has all the tables. > - Migrate your data > > Please read the following resources before you start. > > *See this section in the book:* > > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Copy-data-from-one-db-into-another > The utility script is here: web2py/scripts/cpdb.py > > *Check out this thread: * > https://groups.google.com/forum/#!topic/web2py/mQk2hoRf7gw > > > *Appadmin* > The appadmin allows you to export your data from your old DB. > > > *Be aware of this method:*db.import_from_csv_file() > > > -- 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/ac6b182d-63d2-4500-b10f-3cc479afe047o%40googlegroups.com.