cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
marketware
Level 6

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
Labels (1)
0 Kudos
(4) Replies
KrisVanherck
Level 6

Did you initialize SQL ?

In InstallScript MSI (and i assume InstallScript) projects its
SQLRTInitialize2()


In basic MSI i'm not sure.
0 Kudos
Not applicable

0 Kudos
hidenori
Level 17

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.
0 Kudos
marketware
Level 6

We have reached NIRVANA on this one...thank you all!!!!

bob
0 Kudos