>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.