yingjie
Posts: 4
Joined: Fri Oct 12, 2012 3:38 am

Containing two database, connection detection problem

I have two installation options,

A function modules : the need to connect to the database based on the SQL script to create the database A.

The B function module, need to insert a record into the A database.

I will now integrated into the 1 installation package, such packing must create two predefined database connection, the following are deposited A and B function of different SQL, the installation interface defines how the custom actions and database connection? I tried the use [SqlConnectionString] words login is successful. Thank
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Containing two database, connection detection problem

Hello,

I'm afraid I don't fully understand what you mean. Can you give us more details about your scenario (maybe exemplify)? Also, can you attach a sample with dummy file which try to implement a similar scenario?

However, if you want to create a new database and insert records into database, then you can use our "SQL Scripts" feature. Please keep in mind that this feature is available only in an Enterprise or above project type.

Also, if you want to conditionally run your sql scripts then you can add a SQL connection, on our "SQL Scripts Page", containing your sql scripts. Then, select the related sql scripts and set desired condition in the "Script Condition" field.

Here are a list of articles you can follow:
- Configuring Databases with SQL Scripts tutorial
- ODBC/SQL how to's

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

Return to “Common Problems”