>>>>Hi,
>>>>
>>>>Can a VFP 9 application be affected by TLS? I have never had to do anything in my VFP 9 application as far as TLS. But maybe I have to.
>>>>
>>>>Here is the issue. A customer has VFP 9 application with the SQL Server DB. All users who load the app from their desktops have NO problems.
>>>>
>>>>But when they try to load the application from the VM server (where the application reside), the connection to the SQL Server fails. The error message says SSL Security Error.
>>>>
>>>>Could this have anything to do with the TLS? Or something else?
>>>>
>>>>TIA
>>>You should use new SQL Server ODBC driver. Do not use "SQL Server", but one of the Native Clients (better use 11.0)
>>
>>But if I do that, my understanding, many DB types I use will stop working. For example, VARCHAR(MAX). No?
>
>Yes,
>I think, only varchar(max) will stop.
>I don't know what you use to query the data (maybe SPT), but if you use CursorAdapters or remote views (Grrrrr) you always can use CursorSchema to get MEMO field.

I use CursorAdapter. As far as MEMO vs VARCHAR(MAX).
1. Didn't I hear that MEMO will be deprecated in new SQL Server versions?
2. If I change - via SSMS - the type from VARCHAR(MAX) to MEMO, do I lose all the data?
Thank you very much!