The easiest way is to use OLE DB to query SQL Server instead of ODBC. Doing the query that way will return an ADO Recordset to the DLL, which you can then just use as the RETURN value from the method.

>Hi !!
>
>We have created a DLL in VFP which is accessing SQL Database. We want to return the query result as recordset from the DLL.
>Anybody have an idea to return the ado recordset from the VFP built DLL.
>
>Thanks in advance
>Ravi Mehrotra