>>Well,
>>
>>Sure... I know what an ODBC driver is, but, what's inside it...
>>
>>for example.. if I use ASP with the VFP ODBC driver... and I excute a select statement, is the VFP engine built into the ODBC driver... will it perform the same as it I did the query from the VFP command window?
>>
>
>Yes and no. The ODBC driver communicates with a VFP DLL and passes back results. I guess in theory it should be as fast but it's generally slower due to different and more conservative buffering, resource management.
>
>>Just curious about this when trying to evaluate a module we are going to the that must run on a web browse. It the ODBC driver provides the same speed as native FoxPro access, why not use VBScript to do the whole thing as opposed to writting a VFP automation server and calling the server.
>>
>
>Ahhh...but VBScript can use ADO/OLE DB and run pretty darn fast. Then again, native VFP tables with a native VFP automation server will be faster.
John,
Since there's no OLEDB provider for VFP, you'll need to use the VFP ODBC driver and the OLEDB ODBC provider. This certainly won't be any faster than just using ODBC.