rachan

We have vbscript that will shell out and exectue command that load
transaction log to SQL Anywhere. The DOS command line:

"%SQLANY10%\win32\dbeng10" E:\DbName.db -ek "EncryptionKey" -ad
"e:\TransactionLogDir" -o LogFile

Since SQLANY10 is the system var. (location where SQL Anywhere install)
when the program run we got this error:

'E:\Program' is not recognized as an internal or external
command,operable program or batch file.

We relized that SQLANY10=E:\Program Files\SQL Anywhere 10 and the
program will not run. How do we get around this issue?

LoadTransLogCmd = """%SQLANY10%\win32\dbeng10"" E:\DbName.db -ek
""EncryptionKey"" -ad ""e:\LogFilesDir"" -o E:\LogFile.txt"
RunCmd = "%comspec% /k " & LoadTransLogCmd & ""
objShell.Run(RunCmd), 1, TRUE
WScript.Quit

Best Regards,
Rachan Terrell


--
Rachan
------------------------------------------------------------------------
Rachan's Profile: http://forums.techarena.in/members/rachan.htm
View this thread: http://forums.techarena.in/server-scripting/1041004.htm

http://forums.techarena.in

tom lavedas

Filespecs with spaces in them need to be quoted at the command line.
But, I'm confused, because the code snippet you posted sure looks
correct to me. You have even surrounded paths that don't need the
double quotes with them. Yet, the error message you quote is
definitely indicative of an unquoted pathspec with an embedded space.

I'm at a loss - the only thing I can think is that what you posted is
NOT actually the code that is running. Try 'ECHOing' out the Runcmd
string (in the full code) and examine it carefully to see if there is
an unmatched double quote in the result (though I would expect a
compile time syntax error, if that were the case).

Tom Lavedas
===========
http://members.cox.net/tglbatch/wsh/