>Here's my experience...
>
>SQL Server (version 6):
> 1. Will correctly read varchar(MAX) and the data will come down as a memo field.
> 2. Will read Date and Datetime2 as character strings - not date types even though the data looks like a date.
> 3. Will read smalldatetime and datetime as FoxPro type of T (datetime)
>
>SQL Native Client 10:
> 1. Will *NOT* correctly read varchar(MAX). No data comes down and it comes down as a Character field.
> 2. Will read Date and Datetime2 as date and datetime types
> 3. Will read smalldatetime and datetime as FoxPro type of T (datetime)
>
>SQL Native Client 11:
> 1. Will *NOT* correctly read varchar(MAX). No data comes down and it comes down as a Character field.
> 2. Will read Date and Datetime2 as date and datetime types
> 3. Will read smalldatetime and datetime as FoxPro type of T (datetime)
>
>
>So, it's your pick of the poison.

When you said about ver 10 and 11, "No data comes down and it comes down as a Character field", what you mean by that? I assume you mean the local cursor would be of type Character, but it will be empty? Ok, I could see that.

Well, in my case, I upsized my data from the latest version of the Sedna Sql Server Upsizing Wizard (available from VFPX), and all of my memo fields were uploaded as Text fields in Sql Server, and when I run a SPT query from VFP using either ver 6 or ver 11, I do get data from the DB and it's a memo field.

It doesn't appear that I have any varchar(MAX) fields in my DB, they all appear to be TEXT, and if not, I can certainly change them to be TEXT.

So, I am still at a loss for the pro or cons of ver 6 vs ver 11.

Could there possibly be any performance issues? Also, I have a mix of Widows 7 and Window 8.1 and I'm sure that I'll have some Windows 10 online soon as well. (All 64 bit).