PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WEBDEV 2024 → Is Native MsSQL TLS 1.2 Compatible
Is Native MsSQL TLS 1.2 Compatible
Iniciado por PrinceFemiAdeniyi, 01,jul. 2022 11:33 - 5 respuestas
#1
Miembro registrado
31 mensajes
Popularité : +1 (1 vote)
Publicado el 01,julio 2022 - 11:33
Dear All,

Recently for security reasons, my client upgraded her Db-Server TLS version to 1.2. And immediately all my WB apps could not access the data on MS-Sql 2017. After so much troubleshooting and no success, it was step down to TLS 1.1 temporarily.

Is WB Native MSSQL driver compatible or how do I solve this challenge?

Appreciate all guidance to get this resolved asap. WB is really looking bad as other Apps developed in C#, .Net by other vendors are working on the same server.

Best regards

--
Thanks in advance
Femi
#2
Miembro registrado
50 mensajes
Popularité : +7 (9 votes)
Publicado el 01,julio 2022 - 20:24
What version of Webdev are you using ?
#3
Miembro registrado
50 mensajes
Popularité : +7 (9 votes)
Publicado el 01,julio 2022 - 20:24
I am asking because as you know the drivers are updated as well with each version
Mensaje modificado, 01,julio 2022 - 20:25
#4
Miembro registrado
31 mensajes
Popularité : +1 (1 vote)
Publicado el 02,julio 2022 - 08:24
I am on WB 26. Build 01A2600101d

Thanks

--
Thanks in advance
Femi
#5
Miembro registrado
31 mensajes
Popularité : +1 (1 vote)
Publicado el 12,julio 2022 - 07:10
WINDEVCOL wrote:
> What version of Webdev are you using ?

WINDEVCOL wrote:
I am asking because as you know the drivers are updated as well with each version
Message modified, July, 01 2022 - 8:25 PM


WB 26 01A2600101d

--
Thanks in advance
Femi
#6
Miembro registrado
7 mensajes
Publicado el 14,julio 2022 - 09:14
I did run into something mentioning the upgraded native client, but if I'm understanding this correctly, the App itself would have to be programmed/configured to use the newer driver, correct? Not enough to just install the newer client? This is a noob question I'm sure but my programming chops are basically nil.
I had a similar issue with a a 3rd party client and after some research I found that I had to set SchUseStrongCrypto to true in:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft.NETFramework\v4.0.30319]

&

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft.NETFramework\v4.0.30319]

For my particular issue the client was using 1.2 for most things, but 1.0 for a very specific task.
https://techcommunity.microsoft.com/t5/sql-server-blog/tls-1-2-support-for-sql-server-2008-2008-r2-2012-and-2014/ba-p/384613
https://www.echat.date/omegle / https://omegle.love
→ Volver a WEBDEV 2024