>>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?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham