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 Azure Active Directory interactive mode of the *ODBC* driver through *pyODBC*. The numbers might not match yours but the concept should be the same - pyodbc goes through Microsoft odbc. It's been a while since I have done something with any odbc driver. But my first step would be ensuring Microsoft ODBC is working fine. Maybe you have done that already. I used to just create a connection from, say, MS Office or Access and verify that I could read the data I needed. Then I would move onto whatever app it was that I was trying to set up with odbc. On Sun, 16 Aug 2020, 7:46 pm Andrea Fae', <and...@gmail.com> wrote: > 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 don't know the implication about windows ODBC driver, > pyodbc (it's another odbc driver...so independent from windows ODBC driver > I think), and I don't know exactly if my DAL syntax is correct or not, > because I found different syntax in the web. > If there will be anyone who could help me I will be very grateful. > Thank you so much Villas!! > > Il giorno sabato 15 agosto 2020 17:27:41 UTC+2, villas ha scritto: >> >> >> 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 https://github.com/mkleehammer/pyodbc/wiki >> Note that you should be able to use the pyodbc library independently from >> web2py. >> I hope that other mssql users can give better advice. >> All the best >> >> -- > 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/a3fd7654-838e-416b-b7f6-8c531388979ao%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/a3fd7654-838e-416b-b7f6-8c531388979ao%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CACWMBMPttU-_pmRy3Upsi7ZaZNEeueg41g0ORD_PfEyX%2BZtxbA%40mail.gmail.com.