if you use mssql 2016 you maybe it's better to use this: mssql4://user:password@servername/databasename
I'm not specifying instance, and it seems working. Maybe I will try with the instance too. thanks Il giorno martedì 18 agosto 2020 07:18:06 UTC+2, T.R.Rajkumar ha scritto: > > I use the following. > mssql2://user:pwd@servername\instance/databasename > for connecting to mssql 2016 > I have my webserver apache and web2py running in windows8. > mssql in windows 2016 server. > In servername I use the IP of the machine. > In instancename I have SQL16S7INS1 --- the instance name created by me > when installing mssql > In databasename I have ocms_nlc ---- which is the database I have created > in mssql > In username I give sa. You can give restricted username also if you have > created one and given permission for that user to the concerned database. > > > On Sunday, August 16, 2020 at 3:24:18 PM UTC+5:30 and...@gmail.com wrote: > >> Is it correct this uri to connect to mssql server 2016? >> >> uri = mssql4://user:password@servername\instance/databasename >> >> or >> >> uri = mssql4://user:password@servername/databasename >> (without instance) >> >> Do I have to use "/" for all separations or even "\"? >> >> how can I be sure to use pyodbc or pypyodbc? >> >> Thank you >> >> -- 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/03416bd6-9dfd-4592-be22-1f7e821c6c6fo%40googlegroups.com.