Execute Command prompt in Shell method

Question

0.00/5 (No votes)

See more:

My target executable file location is 'C:\Documents and Settings\Administrator\Desktop\MSI Installer\Dependency Setup\SQL Setup\x86\setup' & Filename is 'setupsql.exe'

I want to do that SQL Server is install in silent mode through creating .iss file which located in 'C:\Documents and Settings\Administrator\Desktop\MSI Installer\Dependency Setup\SQL Setup\Unatteded File\setup.iss'

Directly, it is proper run through command prompt(i.e. c:\>)
After the restart the m/c & uninstall MS SQL server from control panel & delete from MS SQL SERVER folder in c:\Programs, those above exe file and .iss file is run through vb.net coding, it is error msg shown. Msg is 'The path specified in command line argument is invalid: C:\Documents and Settings\Administrator\Desktop\MSI Installer\Dependency Setup\SQL Setup\x86\setup\setup.iss'

My code is below :
-----------------

VB

Dim filePathArg As String = "C:\Documents and Settings\Administrator\Desktop\MSI Installer\Dependency Setup\SQL Setup\x86\setup\setupsql.exe -s -fl ""C:\Documents and Settings\Administrator\Desktop\MSI Installer\Dependency Setup\SQL Setup\Unattended File\setup.iss"""

Shell(filePathArg, AppWinStyle.Hide)

How will i solve the above problem through coding?????
Please help me,it's a very impotant to me....

Posted 30-Dec-11 21:28pm

Member 7678194

Updated 30-Dec-11 23:29pm

Mehdi Gholam

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Answer 1 · 2011-12-31T05:04:00

You need to surround all the filenames with quotes. The shell will otherwise execute whatever is before the first space. Try something like this:

Dim filePathArg As String = """C:\Documents and Settings\Administrator\Desktop\MSI Installer\Dependency Setup\SQL Setup\x86\setup\setupsql.exe"" -s -fl ""C:\Documents and Settings\Administrator\Desktop\MSI Installer\Dependency Setup\SQL Setup\Unattended File\setup.iss"""

Good luck!