>>>Hello,
>>>Does anyone know if there are known issues or problems returning a recordset object from a VFP COM Object to an ASP page? We are able to run this in a Local mode via InterDev and the function/COM Object returns the recordset object without any problems. However, when we attempt to run this on our server the COM object dies when it attempts to return the recordset object to ASP. We are running IIS5.0, Win2K Server, VFP 6 and have all of the latest Service Packs installed.
>>>thanks...
>>
>>What error (if any) does it throw? Is the COM object compiled as a multithreaded DLL?
>
>The COM object is compiled as a multitrhreaded DLL. The error when running via the server is: An exception of Type VBScript Runtime error: Object Required "False" Was not hHandled.
From the looks of it, VFP is returning an unassigned variable to your ASP page (newly created varibale are defaulted to have a .F. as its value).
1. Is VFPCOM registered on the Win2K box?
2. Is your COM object throwing any errors? Are you trapping them and reporting them somehow or are they being consumed?
3. Is ADO installed on the Win2K box? Most likely it is as VFP needs MDAC before installing.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao