Hope I don't go off on too much of a tangent here.

First, try this - http://www.avdf.com/oct98/art_ot004.html

Have you looked into using the RCMD Service for Windows 2000?

The server you are running this from, you will need to install the service and start it.. Then you could have these command executed on the server..

Otherwise, you would need to register the DLL and probably setup and ODBC Connection for each of your clients.

Shawn is right about dcomcnfg. Have you double-checked your permissions? Shoot, that is right.. You said it works right on the console. But, you may need to configure for remote execution..

Another way to do this is to:
"Call" your SQL Server remotely..

code:

---

$strconn = "Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;PWD=Password;DATABASE=Database_Name"
; -- Build a recordset
$objRS = createobject("ADODB.Recordset")
        $objRS.Open "select ID, strParent from Parents", $strconn
; -- etc.

---

Wait.. I found something that may help:
http://www.asp101.com/ado/18350704.asp

Look under the section - "Using the DataFactory Object Directly"

HTH,

- Kent

[ 07 February 2002: Message edited by: kdyer ]