- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Validation with SQLServerSelectLogin2
- 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
Validation with SQLServerSelectLogin2
Hi, I use SQLServerSelectLogin2 to get Sql Server instance from the user.
Lets say, the user selects sql credentials - login and password.
Is there any way (I mean simple solution maybe in InstallScript?) to validate/check if we connect to selected Sql instance with gathered credentials?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Hi @kmisniak ,
How about using function SQLRTTestConnection2 to validate SQL server connection with credentials?
More details you can find from:https://helpnet.flexerasoftware.com/installshield22helplib/Subsystems/installshield22langref/helplibrary/SQLRTTestConnection2.htm#langref_appendixe_619625896_1169203
If you would like to view sample script how it is been used,you can have a look at "EventsConv.rul" file that i am attaching here.It can also be found in <InstallShield INSTALLDIR>\<IS Version>\Script\Iswi\src\EventsConv.rul.
Hope it helps,
Thanks,
Jenifer
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
You can do with InstallScript as Jenifer suggests. For a Basic MSI project an easier way would be to use ISSQLServerValidate action under 'Behavior' on the 'Next' button in the SQLLogin dialog.