/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0
Hi grimmeissen,

Try cmd.exe

Ilikebananas
Answered 09/19/2005 by: Ilikebananas
Purple Belt

Please log in to comment
0
Does that mean I have to put cmd.exe inside my package in order to run that command?
Answered 09/19/2005 by: grimmeissen
Senior Yellow Belt

Please log in to comment
0
Depending on your platform it's in system32 [:)]
Answered 09/19/2005 by: Ilikebananas
Purple Belt

Please log in to comment
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
Answered 09/21/2005 by: sridtech
Senior Yellow Belt

Please log in to comment