The issue with multiple drivers and compatibiluty therein is not a VFP issue but rather a Windows issue. If the driver works on the version of Windows you are using it should work in VFP.

>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