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

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.

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
Answer this question or Comment on this question for clarity