Hello and welcome to our forums,
To achieve what you want you can use the
properties (e.g. SERVER_PROP, DATABASE_PROP, USERNAME_PROP, PASSWORD_PROP, etc) associated with the edit box controls from the SQL dialog where the user enters the SQL connection parameters. You can use
formatted references of those properties on both project views:
1. on "SQL Databases" view to configure the connection string
2. on "Environment" view to configure the value of the environment variables you want to create at install time
Also, under predefined connection, checking the "create database if it does not exist" option doesn't seem to work, since it throws an error whenever the database is missing.
I'm not so sure why this happens. Can you please send us the .AIP (project file) and a
verbose log of the installation to
support at advancedinstaller dot com so we can investigate them?
If you cannot share with us your project file, then you can try to isolate the behavior in a buildable sample (.aip + its referenced files) which we can build and test on our side.
All the best,
Daniel