/build/static/layout/Breadcrumb_cap_w.png

Running DOS Commands From Inside MSI

Hello, I am using Wise 5.1 and I need to run a .sql file that contains transact sql to set up a login on a sql server database. When I run the .sql file from the command line on a server I just use "isql -E -i FILENAME" and everything works fine.

How can I run a DOS command to call isql from inside the Wise installation? Under the custom actions options I only have things like Run a VBScript or Run a Program.

Run a Program forces me to have a .exe file inside the installer to run. I don't want to have to package isql.exe

If there is a simple way to run a DOS command on the host machine from the Wise Script, please let me know.

0 Comments   [ + ] Show comments

Answers (4)

Posted by: Ilikebananas 19 years ago
Purple Belt
0
Hi grimmeissen,

Try cmd.exe

Ilikebananas
Posted by: grimmeissen 19 years ago
Senior Yellow Belt
0
Does that mean I have to put cmd.exe inside my package in order to run that command?
Posted by: Ilikebananas 19 years ago
Purple Belt
0
Depending on your platform it's in system32 [:)]
Posted by: sridtech 19 years ago
Senior Yellow Belt
0
hi grimmeissen,
Perform the following actions in WISE to use the command line within ur package.
* Open your WSI file in WfWI editor. Click on the "MSI Script" tab.
* Click on "Execute Immediate" sequence tab.
* Invoke the CA "Execute Program From path" with a condition "NOT Installed" after the "Install Finalize" action.
* Enter the following information on the "Details" tab for this CA:
Custom Action Name = <YOUR_CUSTOM_ACTION>
Property = %COMSPEC%
Command Line = isql -E -i FILENAME
* Compile and test MSI installation to see if action is executed.

Let me know if you have any problems.

Good Luck,
Srid
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ