Re: [web2py] Re: Server SQL non existent or access denied

2020-08-18 Thread AGRogers
Hi Andrea According to https://docs.microsoft.com/en-us/sql/connect/python/pyodbc/step-3-proof-of-concept-connecting-to-sql-using-pyodbc?view=sql-server-ver15 *pyODBC uses* the *Microsoft ODBC* driver for SQL Server. If your version of the *ODBC* driver *is* 17.1 or later, you *can use* the

[web2py] Re: Server SQL non existent or access denied

2020-08-16 Thread Andrea Fae'
Hello Villas, first thanks so much. You are gently. I will have possibility tomorrow to test. I just installed ODBC driver 17 in my client, so tomorrow I will test first of all if with a windows DSN connection it's possible to connect to SQL server 2016. After it I will try using web2py...But I

[web2py] Re: Server SQL non existent or access denied

2020-08-15 Thread villas
>> Do I have to install any ODBC SQL Server Driver on my client? Hi Andrea I feel your frustration and, although I do not use mssql, I believe you will certainly require a suitable ODBC driver installed so you can then connect to that datasource using pyobc. Maybe this will help

[web2py] Re: Server SQL non existent or access denied

2020-08-15 Thread Andrea Fae'
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,