SQL Connection trouble

[jasonamorris]

Hi,

I am trying to create an installer which will:

Show a SQL Connection dialog (I have managed to sort this)
Change the SQL string based on trusted connection or not (I have managed to do this)
Show a list of available SQL Servers (I have managed to do this)
Test the created SQL Connection string (I have managed to do this)
Run SQL Scripts after creating the Database if it does not exist

The problem I have is that when I use SqlServerBrowseListBox, it works perfectly fine when it is testing the sql connection however it does not work when i user the same SqlServerBrowseListBox property when connecting to run SQL scripts and create the database.

Jason

[jasonamorris]

Hi,

I have managed to get around this by adding another published event on the Next button. This event populates SERVER_PROP with SqlServerBrowserListBox result. That seems to work fine now. However it has lead me to another issue which I need to resolve.

Is there a way of editing (by user) the combo box for SqlServerBrowserListBox? As we know this list is only fully created when SQLBrowser is running.

I want the user to be able to select from the list of SQL Servers if it exists/found, or enter the instance name if it only finds the server etc.

Thanks in advance.

Jason

[Daniel]

Hello Jason and welcome to Advanced Installer forums,

Thank you for your interest in Advanced Installer.

In order to achieve this you can add an additional edit box control (having the SqlServerBrowserListBox associatted property) on your browse for SQL servers dialog, where the user can type the server name.

If you have any questions let us know.

All the best,
Daniel