>>>I have tested my VFP 9 app with the SQL Server Native Client 11. It works in most of the places in the program. But I can't say that it would be 100%. The main place where I have to make changes is the columns VARCHAR(MAX). I have to CAST these columns as a TEXT to make them work with the application. And there are too many places. I would need to go through every one of the features that uses these types of fields. But not ready yet.
>>>Thank you.
>>
>>Casting N/Varchar(max) to TEXT is not an ODBC driver problem, it is VFP one. VFP does not recognize varchar(-1) as a valid type.
>>But if you work with CAs instead of SQL Passthrough you will have no problems if you use CursorSchema property.
>
>I do use the CA. And I believe that CA, as you said, has not problem with the VARCHAR(MAX). But I have places where the data is retrieved from the SQL Server using SQL Select. And these places is where I need to CAST from VARCHAR(MAX) to TEXT. Does it mean that I use the mix of CA and SQL Pass-through?

Yes :-)
If you use SQLEXEC that is exactly what you use :-)