I don't see why it shouldn't work as long as the corrent database is correct one. What exactly doesn't work? What error, if any, do you get?
>isdone=sqlexec(handle,"exec sp_extractproducts","abc")
>
>Using the above code to return a recordset into 'abc', from an SQL Server database does not seem to work.
>
>Any ideas would be appreciated.
>
>The stored procedure is as follows:
>
>CREATE PROCEDURE sp_extractproducts AS
>set nocount on
>select * from soldproducts where qty>0
>GO
>
--sb--