The SQL Native Client includes both, OLE DB provider and ODBC driver in one DLL.
>I found SQL Native Client does not return Varchar(max) to VFP memo fields using SPT where the ODBC driver does. Do you not get these results? (actually, I thought it was you who gave me this solution when I was having trouble with some SPT calls that were not returning data to my memo fields) When i use the ODBC driver I have no problems with varchar(max) and VFP memo fields.
>
>( or am I confused about which driver is the OLEDB - isn't that the SQL Native Client?)
>
>And now I just went back to a test program and I can't seem to reproduce the Memo field problem with SNAC so perhaps I am dreaming all this ?? <s>
--sb--