>Thanks a lot for your answer.
>
>I heard that SQLOLEDB is much faster than ODBC connection. VB support SQLOLEDB connect string ?
>
>Is it a better solution to go with VFP rather than VB ?
>
>Did anybody test SQLOLEDB compared to ODBC ?
>
>Thanks again
Peter,
VB can only access data via ADO. VB does not have the capability to access data directly as VFP does via ODBC.
Tests using ADO have been done with OLE DB and ODBC and I believe OLE DB was faster. However, since you are limited to using it only through ADO, the overhead invloved to convert the ADO recordset into a cursor isn't worth it, if you want to use VFP cursors. If you want to use ADO only, ADO is ADO and it the same speed in VFP as it is in VB.
ADO recordsets are a viable option in VFP. John Petersen wrote a white paper on using it with VFP. It's called ADO Jumpstart and you can find it on the MSDN web wite.
Good luck!
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao