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: SQLServerSelect...What does it see?
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
Jan 09, 2010
10:36 AM
SQLServerSelect...What does it see?
I am using the SQLServerSelect Dialog and I have a question. What servers does it show? When I run it on one of our test machines it seems to display every SQL Server that machine has ever connected to.
So my question is really this; if the install is run on a new PC that has never connected to any SQL Server, will it still display the available servers that are on the network, or will the list be blank because the PC has never connected to any server?
Thanks!!
Bob
So my question is really this; if the install is run on a new PC that has never connected to any SQL Server, will it still display the available servers that are on the network, or will the list be blank because the PC has never connected to any server?
Thanks!!
Bob
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Jan 10, 2010
10:10 AM
Hi Bob,
From what I recall the SQL Login dialogs in both InstallScript and MSI projects rely on windows API's to query for servers. I forget which API it uses exactly, but one checks the domain controller for registered servers, and the other sends out a broadcast ping, and waits until the SQL Browser server on listening PC's responds.
Recent SQL Servers, last I was aware, don't have any effect. Although, this may change if you're talking about Oracle or MySQL, since these use different methods of browsing that I can't say I know much about.
From what I recall the SQL Login dialogs in both InstallScript and MSI projects rely on windows API's to query for servers. I forget which API it uses exactly, but one checks the domain controller for registered servers, and the other sends out a broadcast ping, and waits until the SQL Browser server on listening PC's responds.
Recent SQL Servers, last I was aware, don't have any effect. Although, this may change if you're talking about Oracle or MySQL, since these use different methods of browsing that I can't say I know much about.
![](/skins/images/D60DF682EA37BF37032955CE10F3F0BB/responsive_peak/images/icon_anonymous_message.png)