Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO, VFP DLL and
Message
 
To
07/08/2003 16:34:42
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00817660
Message ID:
00818002
Views:
19
I guess the COM wanted the connection open:-).

There used to be a guy on this board, JVP, but he is no longer participating. However, he has written some [very good] white papers:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp

There is a RecordSet property called Editmode. It might help you a bit if you read JVP's paper at the above URL.

Who is "rush/html/Admin_UserEdit.asp"? Is this your COM, or a vendor's?

You migt try setting step on, and assure yourself that your references and data types are as they should be.

>Terry,
>Thanks for the suggestion.
>
>I placed this code in the page,...
>
>IF Recordset1.ActiveConnection.State > 0
> Recordset1.ActiveConnection.Close
>ENDIF
>
>just Before the DLL call, and get this error:...
>
>Microsoft VBScript runtime error '800a01a8'
>Object required: ''
>/rush/html/Admin_UserEdit.asp, line 160
>
>So I placed it at the End of the page. THAT error goes away, but I still get the Access Denied error.
>
>Is there something happening, perhaps, with the MTDLL not releasing the table? I've shotgunned ALL my Procs with CLOSE TABLE ALL CLOSE DATABASES ALL and CLOSE ALL before the RETURN statements, but No change.

>
>I've looked in numerous Websites as well as my local MSDN help files on ADO,ASP,VBscript, and in VFP on COM and Automation Servers.
>
>I'm pretty confused at this point as to how to proceed.

You'll get it - something is missing - and it will eventually bubble it's way up. You're sure it's not a firewall issue?
>
>Thanks for your help.
>
>David
>
>David
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform