>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.