I will name the name you don't want to name. It was me that said that varchar(max) returns an empty string when using the SQL Native Client 11.0 driver.

I might clarify that my results were from using Sql Pass Through (SPT) and not using the VFP CursorAdapter. I have never used the CursorAdapter, so you might be correct in that it works correctly with these relatively new SQL Server data types.

When I worked at Microsoft and tested the VFP to SQL Server using ODBC and SPT and Remote Views there was no CursorAdapter nor were there SQL Server datatypes of varchar(max), date, datetime2, bigint, etc.

Thanks for even considering that I was a guru - far from the fact!

>Hi,
>
>First, I am using CursorAdapter to connect and update SQL Server tables.
>
>I looked through some old messages and find the gurus (I don't want to name names) warning of not being able to use SQL Server Native Client 11.0 driver. One message says that this driver, when using the type VARCHAR(MAX) will return empty string. However, just a few days ago I replaced the driver SQL Driver with the SQL Server Native Client 11.0 driver (for an in-house application that I use every day). And I don't see a problem, the SQL Server type VARCHAR(MAX) returns to the VFP 9 application the value in the field. The type DateTime is correctly mapped to the DATE type in VFP 9.
>So, I have two questions:
>1. What am I missing in being able to use SQL Server Native Client 11.0 driver without a problem?
>2. I create connection string based on the driver value in XML configuration file. And I see that I replaced the old ODBC driver with the Native Client Driver. Just in case, I miss something, can the VFP 9 code determine what is in fact the SQL server being used?
>
>TIA