Unknown Error

[sshafe]

Has anyone ever seen this error:

"Object required: 'Run(...)'"

I've search all over the net and can't find anything on it or how to fix it.
This is what I'm doing: I am kicking off another script from inside of the main one and getting this error. The strange part is that the one I call, runs and returns the correct results@@@*&$* (I'm puzzled)

 

[hithere]

does the page have any javascript going on? posting the code section would help. have you tried printing out the sql statements and see if there's something weird there? is there a call to an object that hasn't been initialized?

just some thoughts.

"Where's the Ka-Boom? There's supposed to be an Earth-shattering Ka-Boom!"
Marvin the Martian

 

[sshafe]

The script pop us the before call message box, then the error, and then the results of the query.vbs. I'm not familiar enough with all this yet to know if something is missing.

Set WshShell = CreateObject("WScript.Shell&quot
MsgBox "Before call"
Set oExec = Wshshell.Run("C:\query.vbs&quot
MsgBox "After Call"

 

[jonscott8]

You appear to have the Run and Exec method confused.

Either use

Set oExec = Wshshell.Exec("C:\query.vbs&quot

or

nExec = Wshshell.Run("C:\query.vbs&quot

http://msdn.microsoft.com/library/en-us/script56/html/wsmthrun.asp

Jon Hawkins

 

[mrmovie]

sorry to jump in on this thread but what is the difference between the Exec and the Run?
can the vbscript that you are Exec return an object??
and if so how so?

thanks,
von moyla

 

[jonscott8]

Start by referring to

http://msdn.microsoft.com/library/en-us/script56/html/wsmthrun.asp

http://msdn.microsoft.com/library/en-us/script56/html/wslrfexecmethod.asp

In a nutshell, both are used to execute command line applications. The Run method is primarily used when you can pass all necessary info to the child application thru command line switches. The Exec method is primarily used when you need your script to "interact" with the child process, to provide input to a prompt for example.

There are numerous examples already posted in this forum.

Jon Hawkins