Jose
(Seasoned Scripter)
2002-12-01 06:22 PM
Sunday home stuff database

Hi boys [Cool] !! , I am trying to make some sctipt to work (write on Access database) at home that worked at the office. I get the error -COM exception error "Open" (ADODB.Recordset - Operation is not allowed on an object referencing a closed or invalid connection.) [-2147352567/80020009] on this line.
code:
 $rsRecordset=$Recordset.Open($Command) 

At work i have Nt 4.0 with WMI installed and Office 97, al home i have 2000 Professional and Office 2000. I guess 2000 doesnt need WMI to be installed, isnt it?
Tenks


JochenAdministrator
(KiX Supporter)
2002-12-01 09:18 PM
Re: Sunday home stuff database

Jose,

I think that you try to ride a dead horse at home , means that your reference (open=) failed without your script handle this exeception before,
eh, and yes, Windows 2000 doesn't need to have WMI installed [Big Grin]

[ 01. December 2002, 21:18: Message edited by: jpols ]


Jose
(Seasoned Scripter)
2002-12-01 09:40 PM
Re: Sunday home stuff database

true jpols for today iŽll leave him dead on the floor, tomorrow i Žll ride some more at work its no biggy [Wink]
tenks


Sealeopard
(KiX Master)
2002-12-01 11:03 PM
Re: Sunday home stuff database

This has nothing to do with WMI, and, BTW, WMI is installe dby default under Windows 2000.

Anyway, search the UDF Forum for my database UDFs (they all start with DB like DBConnOpen) and try again. However, they all need some kind of database driver installed (like MDAC).


Jose
(Seasoned Scripter)
2002-12-02 03:45 AM
Re: Sunday home stuff database

Yes sealeopard i have MDAC at work, that might be the cause. Tomorrow when i am back iŽll install it and post the result.
Thank you very much.
Chau!


Kdyer
(KiX Supporter)
2002-12-02 06:14 AM
Re: Sunday home stuff database

MDAC?

You can get quite a few versions at - http://www.microsoft.com/data

Be sure to read the notes for each one for the driver limitations.. [Smile]

HTH,

Kent