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.
