Contributions
(58, 2) WshShell.Exec: The system cannot find the file specified.
Hi there. This script has never failed to run before - although it is only run about once a year. The error is the subject above. Here is the offending VBS script: function execQuery(sSQL, sFileName, sStatusText) dim cmdline, oExec, iTime dim bStillRunning bStillRunning = false cmdline = "osql -E -S" & sServer & " -d" & sDatabase & " -w1000 -Q " & chr(34) & sSQL & chr(34) & " -o" & chr(34) & sOutputLocation & "\" & sFileName & chr(34) set oExec = WshShell.Exec(cmdline) wscript.echo sStatusText & " [pid: " & oExec.ProcessId & "] " Do While oExec.Status = 0 WScript.Sleep 100 iTime = iTime + 1 'if iTime > 100 then 'wscript.echo vbtab & "...continuing asynchronously with other scripts. " 'WScript.Echo vbtab & sFileName & " will be available when processid " & oExec.ProcessId & " terminates" 'WScript.Echo 'bStillRunning = true 'exit do 'end if Loop if bStillRunning = false then WScript.Echo "........COMPLETED [" & sOutputLocation & "\" & sFileName &"]" WScript.Echo end if end function I am not a script writer or programmer ...please help! This vbs script is being called by a batch file. The bold above is line 58 Thank you Ken705Views0likes1Comment