I have a Web App that requires a database for it to run. I used a third party (Red Gate SQL Packager) tool to create a .exe file for me for database installation. I added it as Temporary File in my project. I then, created Custom Action "RunAsAdmin" with the following Properties:
Source Path: <AI_CUSTACTS>aicustact.dll
Source Type: Executable.exe
Command Line: [&sqldata.exe] -> this points to my .exe file created by SQL Packager
Execution Property: Synchronous Execution, check return code.
Execution Option: Immediate execution
Scheduling Option: Always Execute
Then, in my Dialog Page, I added a New Event under "Published Events" on the "Next" button of FolderDlg (I want the database installation to take place before the installation of the package starts). This event points to the Custom Action "RunAsAdmin" and has the following property:
Event: DoAction
Argument: RunAsAdmin
Condition: AI_INSTALL
But when I run my installer (after building it), the installation failed with the following error:
"There is a problem with this Windows Installer Package. A program required for this install to complete could not be run."
I checked my .exe (sql packager) file and it was not corrupted. When I double-clicked it, it run.
By the way, the sql packager exe file prompts the command line before running (maybe this info could be helpful).
Am I missing something?
I really need your help.
Thanks!
FOLLOW US
Get the latest news in Application Packaging