I know that VFP tables are limited to 2 gig. But I also mention the possibility of C++. If we use C++, OLE DB/ADO, is the resulting dataset as retrieved by ADO limited to 2 gig? Suppose VFP is only instantiating ADO, can ADO retrieve a dataset larger than 2 gig?

Thanks,
Steve


>Hi Stephen,
>
>The size of the VFP tables is limited to 2Gb regardless where data is comming from.
>
>>In time we will have the need to transfer potential data sets in excess of 2 gig for viewing by an end user from terabytes of data. We need to know the best connectivity to use for this: ODBC (currently used), ADO, OLE_DB, etc. what's the fastest and best for this application? The current application is also written in VFP and we need to know if the 2 gig size limit will affect the return of data or whether VFP will need to be converted to C++ in order to accomodate these larger data sets. Even if C++ is eventually used, we'd still need an answer for the connectivity method to a SQL-Server or Oracle backend.
>>
>>Thanks,
>>Steve