Hi,
>Hi Viv, I've not heard of SETRESULTSSET
What version of VFP are you running ( I think SETRESULTSET came in VFP9 - but it may work with the OLEDB provider anyway) . SP just needs to be something like:
SELECT * FROM xxx INTO CURSOR myCursor
RETURN SETRESULTSET("MyCursor")
, also what sort of object is oConn ?, cheers
oConn was just an existing IDBConnection to the VFP data.....
Regards,
Viv