Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TLS Browser and VFP
Message
From
11/12/2020 13:12:43
 
General information
Forum:
Internet
Category:
Other
Miscellaneous
Thread ID:
01677516
Message ID:
01677522
Views:
40
>>>Hi,
>>>
>>>Could someone explain to me how TLS relates (technically) to the ODBC driver used when a VFP 9 application connects to the SQL Server? Every page I google for the TLS version and enabling points to having to do it in a Browser.
>>>But the VFP connects to the SQL Server via the ODBC driver, not browser. So, what actually goes on "under the hood"?
>>>TIA
>>
>>TLS (Transport Layer Security) is a cryptographic protocol designed to provide communications security over a computer network (not only the Internet)...
>>https://en.wikipedia.org/wiki/Transport_Layer_Security
>>TLS 1.2 is currently the recommended standard. Support for SQL Server is documented here:
>>https://support.microsoft.com/en-us/help/3135244/kb3135244-tls-1-2-support-for-microsoft-sql-server
>
>Thank you. I will go to the articles. But what if a computer does not have a Browser. How do you set the TLS enabled and to a version?

TLS is a protocol. Web browsers are probably the most commonly used apps which implement it, but other types of apps may as well.

In the case of web browsers, the browser client and the web server back end agree to use TLS to encrypt communications between them. In the case of SQL Server, the ODBC client and the SQL Server instance agree to use TLS to encrypt communications between them, assuming:

- Both the ODBC client and SQL Server instance support it
- You've opted to enable it while creating the connection between them e.g. encrypt=yes in the connection string

The nuts&bolts are outlined at https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine .
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform