santoshadvanceinst
Posts: 22
Joined: Mon Nov 05, 2012 12:19 pm

Database server selection

Hi,

As a part of my product installation I want user to give me database server type (Oracle, SQL server etc.), username, password and port. Once this information is captured I would like to execute a script that is bundled with the package and update XML file. Updating XML is fine and can be done. I would like to know the best solution for database selection and execution of script. Also do you support DB2 as a database to execute script. I am trying to target SQL server, Oracle, MySQL and DB2 as 4 possible back end databases to execute the script.

Thanks in advance.

Santosh
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Database server selection

Hello Santosh,

To achieve what you want you should create your own SQL connection dialog on which you can have a combo box control (e.g. SERVER_TYPE) letting the user to select the SQL server type . Then in "SQL Databases" page you should create three SQL connection: the first targeting Microsoft SQL Server, the second targeting Oracle and the third targeting MySQL. Each of this connections should use in their condition field the "SERVER_TYPE" property and should include the requested SQL script to be run during installation.

Regarding DB2 Servers, I'm afraid we don't have built-in support for them. As a workaround you can create your own custom action which will establish the connection and run the requested SQL script.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”