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.
