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
- :
- How to get SQLServerSelect() to Display Available SQL Servers?
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 01, 2010
06:40 PM
How to get SQLServerSelect() to Display Available SQL Servers?
OK. Can anyone tell me the magic of getting this function to work properly?
It doesn't display any servers in the drop down list, nor does it work if you press the Browse button. I would really like it to work as intended. I assume the folks at Flexera built it to work, so what's the magic formula?
All I need is the available SQL servers, I don't plan on running any queries against the server from the installer. I understand that it may only find those servers on the network that support TCP/IP, and that's just fine.
Thanks!!
bob
It doesn't display any servers in the drop down list, nor does it work if you press the Browse button. I would really like it to work as intended. I assume the folks at Flexera built it to work, so what's the magic formula?
All I need is the available SQL servers, I don't plan on running any queries against the server from the installer. I understand that it may only find those servers on the network that support TCP/IP, and that's just fine.
Thanks!!
bob
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 04, 2010
03:00 AM
Did you initialize SQL ?
In InstallScript MSI (and i assume InstallScript) projects its
In basic MSI i'm not sure.
In InstallScript MSI (and i assume InstallScript) projects its
SQLRTInitialize2()
In basic MSI i'm not sure.
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)
Not applicable
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 04, 2010
03:04 AM
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 04, 2010
10:46 AM
Please make sure that you have at least one connection in the SQL Scripts view. The SQLBrowse dialog is designed to work in conjunction with the view.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 04, 2010
07:19 PM
We have reached NIRVANA on this one...thank you all!!!!
bob
bob
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)