Hi Kelly,
I think that SPT (ODBC connection) would be the best choice in your case.
>I am trying to get some benchmarking information for an upcomming project concering a VFP application that uses SQL server as a back end. What we have now is an ODBC connection that is called using the SQLCONNECT() and SQLEXEC() functions. What I need to deterine is, is this the fastest and most efficient manner to retrieve a set of information?
>
> Things that I have to consider:
> 1. ODBC vs. OLE?
> 2. If I use OLE, how can I mimic the functions that I am currently using?
> 3. Is there a better way of accessing a portion of data froma SQL table other than what has been used now, i.e. ado object or cursor adapter?
> 4. If I use these other avenues how would I call a stored procedure and return the results?
>
>What I need is just a good starting point so I can run some tests and make an informed decision.
>
>Thanks in advance
>Kelly
--sb--