On Monday, June 22, 2020 at 2:10:35 AM UTC-7, Davidiam wrote:
>
> UPDATE : I managed to find the solution so I will post it here for any
> others that have the same issue :
>
> We had to install a new ODBC driver and to modify the MS SQL connection
> string.
>
>
Thank you, followups are good for the record!
Glad to hear you got it sorted.
/dps
> Old string :
>
> uri = mssql://DRIVER={SQL Server}
>
>
>
> New string :
>
> uri = mssql://DRIVER={ODBC Driver 13 for SQL Server}
>
>
>
> We then ran into problems with web2py trying to recreate the auth tables
> which already existed.
>
> gluon.contrib.pypyodbc.ProgrammingError: ('42S01', "[42S01]
> [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]There is already an
> object named 'auth_user' in the database.")
>
>
>
> To resolve this, we then needed to add "fake_migrate=True" to our DAL
> connect string. After doing this we no longer got an error and everything
> worked correctly. We then removed the fake_migrate parameter and it
> continued working correctly.
>
>
> On Friday, June 19, 2020 at 7:44:53 AM UTC+2, Davidiam wrote:
>>
>> Good Morning,
>>
>> I would like to know what I would have to modify in order to connect to
>> MS SQL from web2py with TLS 1.2. We are running web2py 2.18.5 on a Windows
>> 2016 IIS server.
>>
>> Yesterday a security patch was installed to disable TLS 1.0 and 1.1 and
>> enable TLS 1.2 and now all our MS SQL DB connections are failing.
>>
>> Thank you very much for your help on this, I would appreciate a rapid
>> reply as our development in web2py is now blocked due to this.
>>
>> Kind Regards,
>> David
>>
>
--
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/023a3e9a-ba57-41cd-80c2-d9067feff171o%40googlegroups.com.
