setting activeconnection to nothing

[j3...@my-deja.com]

In VB a recordset can be persisted by setting the ActiveConnection
property to "Nothing". Then the connection can be destroyed without
affecting the RecordSet.

I cannot get this to work in Perl. I've tried using undef, tried
setting it to '', among others. Nothing seems to work. The
ActiveConnection property still references the current connection.

Does anybody have a suggestion?

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy.

[Tobias Martinsson]

You need to:

use Win32::OLE::Variant;

...

$rst->{ActiveConnection} = Variant(VT_DISPATCH);

...

Your post lead me to find an error for placement in the errata for my
"ActivePerl with ASP and ADO" book. (It's like a dagger through the
heart everytime I find an error!)

Thanks
--
Tobias

[j3...@my-deja.com]

Thanks. I'll give this a try.
In article <8do4pd$mmm$1...@nnrp1.deja.com>,