How to show error message at the time of installation

[sagar]

Hi,
I have created installation project for our application. In this installation project I am creating new database by using predefined SQL connection, Also I have added create script of table & store procedure .Now problem is that when I try to install our application installer is running fine until it copy our project to machine but at the time of creating database & executing SQL script if any error occurs installer directly rollback without showing me error message.
e.g. if I am creating database with name of "Test", If that database is already present then installer must show error message that "Test database is already present".At present it is not showing me any message.
Please tell me solution for above problem.

[mihai.petcu]

Hello,

Unfortunately the Windows Installer SQL script error policy does not include showing a message.
There are currently three available options which you can set from the SQL script right pane:
- Abort installation ( which you most probably have set in your project )
- Go to the next script of the connection
- Go to the next statement in the script file

If you need to show a message, you can try to do so from within your own custom action.

All the best,
Mihai

[sagar]

I have attached 2 project Demo.api & Demo2.api. In both project I am executing SQL create table script.In Demo2 project when In Test database If table is present then installer show me error message "Their is already object name tblTableName" but in Demo project I am not getting that error message, Installer will directly rollback so because of this user will not understand why setup get rollback. I want to display that error message.
please tell me solution to display that error message

[sagar]

Do you get solution for my problem?.

[Cosmin]

Hi,

Try checking the Connection and all its scripts are verbose option for your SQL connection. This way if an error is encountered, it will be shown in a message box.

Regards,
Cosmin

[sagar]

Thanks it work