[Confused]

When I run clpowell's "output to DB script" it breaks at "$cmd.commandtext = $CMDtxt $rs.Open ($cmd)" with @error @serror as follows: -2147352567 COM exception error "Open" (ADODB.Recordset - The connection cannot be used to perform this operation. It is either closed or invalid in this context.) [-2147352567/80020009]

A simple test script (using Jen's db udf collection) just to open a conn, open a set, do nothing, and close also fails on "dbrecordopen" with the same @error @serror.

(Since I've run a non-related vbs script with output to a DB successfully, I am guessing that my OLE stuff is correct.)

In other words, I can output to db using vbs but not with kix...

The environment is XP Pro, Access97, Kix410a

Any troubleshooting inspiration would be helpful...

tia
_________________________
We all live in a Yellow Subroutine...