RE: Any Examples of COM (and perhaps ADO)?

["Paul Steckler" <steck@ccs.neu.edu>]

> My version of DrScheme and MzScheme are plain old "103", according to
> the
> About box and the "(version)" function.  I downloaded MysterX 103-p3
> much
> more recently.  Should I upgrade DrScheme?

No, DrScheme is still (alas) at 103.

> > Have you tried the same experiement in plain MzScheme?
> 
> I just did.  You'll be pleased to know I haven't been able to
> duplicate the
> error under MzScheme.  The problem seems to only happen on the second
> and
> subsequent presses of the Execute button in DrScheme.  Since MzScheme
> doesn't have an equivalent to the Execute button (does it?), I can't
> duplicate the error.  Repeatedly loading the same file using (load
> "adotest.scm") in MzScheme did not cause a problem.

Yes, I'm able to duplicate the problem in DrScheme, and verify that it
works fine under MzScheme.

> After that's happened, any subsequent presses of
> Execute will fail.

And that narrows down the problem.  MysterX does some special cleanup
when the Execute button is hit.  That cleanup code is a hack,
unfortunately, and may be having unintended effects.  

But now I know where to look for the problem.

> One difference is that the ADO objects are using external resources,
> like
> database connections through an ODBC or OLE DB driver.  Most Excel
> objects
> would not be doing anything comparable, and would only be using
> resources
> internal to the Excel COM servers.  How that relates to the behavior
> I'm
> seeing, I have no idea...

Probably not at all.

I'll try to have a patch soon.

-- Paul