>Thank you for response. I know that the ODBC with driver=SQLServer works well with SQLServer(2008). I am afraind that there will be newer features in SQL Server which would require to use SQL Native client, and the varchar(max) issue would be a show-stopper in such case. I looked in other forums and found that the same issue exists in Excel->SQLServer->SQLServer(2008) - Microsoft confirmed that the problem is known to them and they are working to fix it (in relation with Excel). It was not clear in what layer the fix will be applied to though. Did anyone submitt this bug to Microsoft in relation with VFP? Any hints from Microsoft?
The only way to find out status of this bug, is to call MS VFP support and open support incident for it.
--sb--