>>I had been using SQL Server as the database back-end for almost all my VFP apps since the late 90's. No DBCs or anything - just straight SQL pass-through. Never looked back - SQL removed any concerns about data reliability and capacity.
>>
>
>Just curious, did you have the problem with Memo fields using SQL pass-through from Varchar(max) into Foxpro view, and how did you solve it? Do you use a particular ODBC driver?

I haven't had any problems with varchar(max) pulled down to cursors as memo types (that I recall anyway).

I'll have to check connectionstrings in my projects to see what I was using for the driver. It wasn't anything special.