%comspec% 1

[Brycspain]

I create a lot of websites in my environment and would like to use a script to run my setspn commands. I can do it like this however, it defeats the purpose unless I can inject variables with input boxes or arrays.

objShell.Run("%COMSPEC% /k Echo Y| setspn.exe -A http/testsite server1", 1, True)

I would like to place a website and server variable like this but it throws unterminated string constant errors. I've tried several combinations of strings and quotes and I'm stuck.

objShell.Run("%COMSPEC% /c Echo Y| setspn.exe -A http/" & objWebsite & " " & objServer", 1, True)

I know the quotations are wrong but I can't find any examples of variables being used within a comspec statement...can someone point me in the right direction please?

 

[EBGreen]

you have an extra "

objShell.Run("%COMSPEC% /c Echo Y| setspn.exe -A http/" & objWebsite & " " & objServer[red]"[/red], 1, True)

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Brycspain]

That worked, thanks EB...I guess the command really needs to be within the ( ) and not within the " Since objserver was outside the quotes it didn't look right.

 

[PHV]

Either:
Call objShell.Run("%COMSPEC% /c Echo Y| setspn.exe -A http/" & objWebsite & " " & objServer, 1, True)

or:
objShell.Run "%COMSPEC% /c Echo Y| setspn.exe -A http/" & objWebsite & " " & objServer, 1, True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886