|
|
|||||||
Hi boys !! , 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: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?$rsRecordset=$Recordset.Open($Command) Tenks |
||||||||
|
|
|||||||
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 [ 01. December 2002, 21:18: Message edited by: jpols ] |
||||||||
|
|
|||||||
true jpols for today iŽll leave him dead on the floor, tomorrow i Žll ride some more at work its no biggy tenks |
||||||||
|
|
|||||||
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). |
||||||||
|
|
|||||||
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! |
||||||||
|
|
|||||||
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.. HTH, Kent |