Page 1 of 1 1
Topic Options
#90121 - 2002-12-01 06:22 PM Sunday home stuff database
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
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
_________________________
Life is fine.

Top
#90122 - 2002-12-01 09:18 PM Re: Sunday home stuff database
Jochen Administrator Offline
KiX Supporter
*****

Registered: 2000-03-17
Posts: 6380
Loc: Stuttgart, Germany
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 ]
_________________________



Top
#90123 - 2002-12-01 09:40 PM Re: Sunday home stuff database
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
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
_________________________
Life is fine.

Top
#90124 - 2002-12-01 11:03 PM Re: Sunday home stuff database
Sealeopard Offline
KiX Master
*****

Registered: 2001-04-25
Posts: 11164
Loc: Boston, MA, USA
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).
_________________________
There are two types of vessels, submarines and targets.

Top
#90125 - 2002-12-02 03:45 AM Re: Sunday home stuff database
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
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!
_________________________
Life is fine.

Top
#90126 - 2002-12-02 06:14 AM Re: Sunday home stuff database
Kdyer Offline
KiX Supporter
*****

Registered: 2001-01-03
Posts: 6241
Loc: Tigard, OR
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
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's

Top
Page 1 of 1 1


Moderator:  Shawn, ShaneEP, Ruud van Velsen, Arend_, Jochen, Radimus, Glenn Barnas, Allen, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 262 anonymous users online.
Newest Members
gespanntleuchten, DaveatAdvanced, Paulo_Alves, UsTaaa, xxJJxx
17864 Registered Users

Generated in 0.053 seconds in which 0.022 seconds were spent on a total of 12 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org