R1ussell
Posts: 7
Joined: Fri Aug 14, 2009 2:51 pm

SQL Server Browse not working

Hi,
I want my user to be able to pick an SQL Server instance from a list of available instances. I read the user guide it said to either add the 'SQLConnectionDlg', swap the server edit text box for a combo-box and set the value in the property name to SERVER_PROP. Or to use any dialog, add a combo-box and sets it's property name to 'SqlServerBrowseComboBox'. I have tried both of these and when run both methods give me an empty combo-box even though there are severl SQL server instances available both locally and in the network neighbourhood. What's going wrong?

Thanks.

Russell.
R1ussell
Posts: 7
Joined: Fri Aug 14, 2009 2:51 pm

Re: SQL Server Browse not working

I've sorted it myself now.

The answer is that the help file isn't very clear. You need to contiune into the section entitled 'Configure the Connection' and create a custom UI action to do the browsing and attach it to the dialog you created in the previous step entitled 'output'.

Return to “Common Problems”