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: Listing Network SQLServers
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
‎Jun 22, 2007
11:22 AM
Listing Network SQLServers
I am new to Installsheild and currently evaluating Installsheild 2008. We have requirement to show custom dialog where user have option to select Local SQL server or Network SQL server. If he selects Network, we want to display a dialog with list of network SQL servers.
How can I acheive this functionality? Should I create Basic MSI or Installscript MSI project?
How can I acheive this functionality? Should I create Basic MSI or Installscript MSI project?
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 25, 2007
10:52 PM
If you add a connection in the SQL Scripts view (for either Basic MSI or InstallScript MSI projects), InstallShield adds dialog boxes and such for selecting a database server, database, and authentication method. The online help describes how to modify the default behavior.
I believe the SQL functionality is similar enough between the project types that you don't need to base your overall project type on the SQL functionality, but instead on your larger requirements...
I believe the SQL functionality is similar enough between the project types that you don't need to base your overall project type on the SQL functionality, but instead on your larger requirements...
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jun 26, 2007
07:40 AM
I added default connection in the script view and the added these 2 lines in the script to display SQL Server list:
SQLRTInitialize2();
nResult = SQLBrowse( svServer );
It worked great! Thanks for your reply.
SQLRTInitialize2();
nResult = SQLBrowse( svServer );
It worked great! Thanks for your reply.
![](/skins/images/8C9D13A71C7F7695F3262372C0172D68/responsive_peak/images/icon_anonymous_message.png)