cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
bobmcm461
Pilgrim

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.
Labels (1)
0 Kudos
1 Reply
hidenori
Pilgrim

Re: Multiple SQL Connections

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.
  • 0 Kudos