I've created an in-process ActiveX Automation server (myServer.dll) from VFP 5.0. It runs on the Web server. I am going to use the OLEPublic method, BuildTable, to pull complex information from a Fox DBC for Active Server Page access. That way the ASP can just read a MUCH simpler table-- re-writing all the Fox logic in VB (ASP) would be a maintenance nightmare. I want to use the same code to generate the 'report' cursor that I use in my Fox app. Isn't that the purpose of the ActiveX pardigm??

I am using ASP for the entire Web site. It pulls data from FOX dbc (like passwords) I currently am using FOXISAPI to implement complex business logic used to do the reports. For many reasons (availability of ASP session variable for one), I would like to move all this to ActiveX Automation Server on the Web box.

My problem: The first time I create the object (foo) and then call the method to create the report.dbf, it works fine. The ASP script throws an error(Object Required: foo) when I execute 'foo = Nothing' (VBScript) But yet its not released?? How do I release from memory the DLL? I can't get rid of it without rebooting the server! This means I can't re-build it either. Help.

Thanks,
Brent Sliefert