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
- :
- Run SQL Script w/o SQL login dialog
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
‎Jul 10, 2008
07:58 AM
Run SQL Script w/o SQL login dialog
I have an installation that includes 2 sql scripts. One both or neither will run depending on the features selected. One of them needs the sql login but the other does not. Is there any way to disable the sql login screen for one of the scripts?
TIA
TIA
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 10, 2008
10:44 AM
What project type are you using?
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 10, 2008
10:49 AM
installscript msi project, 2008 version.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 10, 2008
11:11 AM
You need to modify the OnSQLLogin() event to show the SQLLogin dialog only for one particular connection as follows:
.
.
if(szConnection = 'ConnectionName') then
nResult = SQLServerSelectLogin2( szConnection, szServer, szUser, szPassword, bWinLogin, szDB, FALSE, TRUE );
endif;
.
.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 15, 2008
08:14 PM
That helped alot. It was a little more complicated but that definitely got me where I wanted to be.
Thanks
Thanks