I have built a very simple COM DLL using VFP 6.0. I use the Object in an ASP page. Then when I return to VFP to edit and recompile the DLL I get a File Access error.
Here is the code in my ASP that is using the Object. (I had to strip some of the HTML stuff to be able to post this.)
.
HTML STUFF
.
1 Dim cPONum
2 Dim oOrder
3 Dim oRs
4 cPONum = Request.Form("txtPONum")
5 Set oOrder = Server.CreateObject("WEBTEST.PurchaseOrders")
6 Set oRs = Server.CreateObject("ADODB.RecordSet")
7 oRs = oOrder.getpo(cPONum
.
HTML STUFF
.
8 The PO Number is = oRs("ponum")
9 The Vendor is =oRS("name")
10 The Account is =oRS("a_name")
.
HTML STUFF
.
11 Set oOrder = Nothing
12 Set oRs = Nothing
.
HTML STUFF
.
Line 5 is where the object is being created. I thought that I was
destroying the object in line 11. Hoever, the DLL is being locked or left open after this ASP runs and I cannot recompile the DLL unless I reboot my machine.