Question about Run with quotes

[secun]

Can someone tell me why this line of code won't work?

Run ("c:\msderela\setup SAPWD=""MyFavoritePassord"" TARGETDIR=C:\MSDE

SECURITYMODE=SQL")

I've also tried:

Run ('c:\msderela\setup SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE

SECURITYMODE=SQL')

Thanks!!

[MarkMarkMark]

tried @comspec ?

[Xander]

Try:

Run ("c:\msderela\setup SAPWD=" & Chr(34) & "MyFavoritePassword" & Chr(34) & " TARGETDIR=C:\MSDE SECURITYMODE=SQL")

[DaleHohm]

Can someone tell me why this line of code won't work?

Run ("c:\msderela\setup SAPWD=""MyFavoritePassord"" TARGETDIR=C:\MSDE

SECURITYMODE=SQL")

I've also tried:

Run ('c:\msderela\setup SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE

SECURITYMODE=SQL')

Thanks!!

<{POST_SNAPBACK}>

Both of these generate the command:

c:\msderela\setup SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE SECURITYMODE=SQL

Does this work withoug error from a DOS command prompt?

[secun]

Both of these generate the command:

c:\msderela\setup SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE SECURITYMODE=SQL

Does this work withoug error from a DOS command prompt?

<{POST_SNAPBACK}>

Yes.

[secun]

Try:

Run ("c:\msderela\setup SAPWD=" & Chr(34) & "MyFavoritePassword" & Chr(34) & " TARGETDIR=C:\MSDE SECURITYMODE=SQL")

<{POST_SNAPBACK}>

I tried this. The response was

Error: Unable to execute the internal program.

[secun]

tried @comspec ?

<{POST_SNAPBACK}>

No. I'm new to this.

Can you give me an example?

[MarkMarkMark]

Run(@ComSpec & " /C c:\msderela\setup SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE SECURITYMODE=SQL ")

im not sure if i have the correct """""""" didnt test it mayb add some ' ' or ""

[DaleHohm]

Both of these generate the command:

c:\msderela\setup SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE SECURITYMODE=SQL

Does this work withoug error from a DOS command prompt?

<{POST_SNAPBACK}>

The following script may help you debug. It shows parameters as they are consumed by an autoit script... your program may in fact handle them differently, but not likely.

;ShowParams.au3
$str = "Number of Params: " & $CmdLine[0] & @CR
For $i = 1 to $CmdLine[0]
    $str = $str & "Param" & $i & " " & $CmdLine[$i] & @CR
Next
MsgBox(0,"Param Test", $str)

Assuming you put this script in c:\, you run it like this:

autoit3 c:\ShowParams.au3 SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE SECURITYMODE=SQL

I think you'll see that you most likely need another set of quotes around the password string... like this:

Run('c:\msderela\setup SAPWD=""MyFavoritePassord"" TARGETDIR=C:\MSDE SECURITYMODE=SQL')

Dale

[secun]

Assuming you put this script in c:\, you run it like this:

autoit3 c:\ShowParams.au3 SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE SECURITYMODE=SQL

I think you'll see that you most likely need another set of quotes around the password string... like this:

Run('c:\msderela\setup SAPWD=""MyFavoritePassord"" TARGETDIR=C:\MSDE SECURITYMODE=SQL')

Dale

This didn't work either. It gave the same result.

Are we missing something simple? Is there a way in AutoIT to break it down into sections like:

Run ("notepad.exe", "c:\mytestfile.txt")

Thanks again for everyone's help.

[secun]

Run(@ComSpec & " /C c:\msderela\setup SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE SECURITYMODE=SQL ")

im not sure if i have the correct """""""" didnt test it mayb add some ' '  or ""

<{POST_SNAPBACK}>

Wouldn't this display my password when it runs? That kind of defeats of the purpose.

[scriptkitty]

try

Run(@ComSpec & ' /C c:\msderela\setup SAPWD="MyFavoritePassord" TARGETDIR=C:\MSDE SECURITYMODE=SQL ',"",@SW_hide)

the comspec only opens for a sec or less to launch the other program. You can minimise it, or hide it completely. Not perfectly safe, but nothing really is.

[DaleHohm]

So what error are you getting exactly? Did you try playing with the ShowParams.au3 script I gave you to see if it helped with your debugging?

Dale

[secun]

So what error are you getting exactly?  Did you try playing with the ShowParams.au3 script I gave you to see if it helped with your debugging?

Dale

<{POST_SNAPBACK}>

------------------------------------------

I just tried it and it was enlightening.

Number of params: 4

Param1 c:\msderela\setup

Param2 SAPWD="MyFavoritePassord"

Param3 TARGETDIR=c:\msde

Param4 SECURITYMODE=SQL

Shouldn't 2,3, and 4 all be one parameter? Isn't that part of the problem?

Hmmm... What if I enclose 2-4 in quotes...

It's late here. I'll try it tomorrow.

[secun]

Well... I feel really silly.

The answer was to fully qualify the executable name.

"c:\msderela\setup.exe SAPWD=""WAFSFieldEstimator"" TARGETDIR=C:\MSDE SECURITYMODE=SQL"

Thanks again for everyone's help!!