PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WEBDEV 2024 → Is Native MsSQL TLS 1.2 Compatible
Is Native MsSQL TLS 1.2 Compatible
Started by PrinceFemiAdeniyi, Jul., 01 2022 11:33 AM - 5 replies
#1
Registered member
31 messages
Popularité : +1 (1 vote)
Posted on July, 01 2022 - 11:33 AM
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
Registered member
50 messages
Popularité : +7 (9 votes)
Posted on July, 01 2022 - 8:24 PM
What version of Webdev are you using ?
#3
Registered member
50 messages
Popularité : +7 (9 votes)
Posted on July, 01 2022 - 8:24 PM
I am asking because as you know the drivers are updated as well with each version
Message modified, July, 01 2022 - 8:25 PM
#4
Registered member
31 messages
Popularité : +1 (1 vote)
Posted on July, 02 2022 - 8:24 AM
I am on WB 26. Build 01A2600101d

Thanks

--
Thanks in advance
Femi
#5
Registered member
31 messages
Popularité : +1 (1 vote)
Posted on July, 12 2022 - 7:10 AM
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
Registered member
7 messages
Posted on July, 14 2022 - 9:14 AM
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
→ Go back to WEBDEV 2024