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/23fcb03f-38e4-4c44-b74e-d36ee54647a7n%40googlegroups.com.
