This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Multiple SQL Connections
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Oct 25, 2012
10:08 AM
Multiple SQL Connections
I am working on an InstallScript MSI package. I need to install databases on 2 different servers. I can create 2 different connections, 1 for each server, and create new properties for each one. When the Database Server Login Dialog box is displayed for each connection, they both look the same. Is there a way to change the title for each one to prompt for which database is being requested. For example "Select Local Database", or "Select Server Database".
Thanks,
Robert M.
Thanks,
Robert M.
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Nov 05, 2012
02:08 PM
You can show the name of the connection that is associated with the connection information by setting TRUE to the bShowCxnName parameter of the SQLServerSelectLogin2 function.
[LIST=1]
Go to the InstallScript editor.
Select the Before Move Data category and the OnSQLLogin event from the dropdown lists.
Find the SQLServerSelectLogin2 function call and change the 7th parameter to TRUE.
Rebuild your setup.
Hope that helps.
[LIST=1]
Hope that helps.
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)