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.
