I am trying to write ASP code to access VFP tables. My thoughts are the most efficient method would be to use OLE DB and run queries via stored procedures inside the VFP 8 database. Thus far I have not been able to figure out (or maybe it is not possible) how to pass results of a query from the stored procedure back to the ASP engine. I can successfully call the stored procedures (for example returning a string works), so I know I have the communication path working. I also was able to send a query from ASP and get the result set, but I don't think sending all of the SQL I will be writing back and forth from ASP is the best means. So my questions are:

Are my thoughts in the 2nd sentence above correct and possible? If not, what is the most efficient means of data i/o to a VFP database? If so, does anyone have a working example?

I can post code examples if needed. Right now I get 'True' returned instead of the record set.