The answer is a solid .. it depends.

How much data is being passed from the VFP COM objects to ASP? If it's alot, then go with OLEDB. If not, I would suggest ODBC.

However, performance is rarely a reason to move from VFP to SQL Server. You can usually solve the problems by making sure the queries are fully optimized.


>Hi,
>
>I am switching my main search in the application from VFP to SQL due to performance problems. I am running an ASP - VFP COM with 40 sites.
>
>My question is:
>
>should I use ODBC to connect to the SQl database from VFP or should I use OLEDB?
>
>using OLEDB - gives me back record sets - how to convert them to VFP cursors? isn't this going to impact the performance?
>
>Thanks