When I create a new setup project and add the SQLServerConnectionDlg to the "First Time Install" sequence of forms, I can't get the database combobox to populate with databases. If I click Back and then Next, the combobox is populated. I would prefer the combobox get populated when I click on the ShowDatabases button (...). Please help.
First of all, I apologize for the delayed reply, but we do not work on weekends here.
In order to get the combo-box populated with your databases, all you have to do is to press the "..." ("Browse") button which is located to the right side of the "Databases" field. Please keep in mind that the combo-box does not get populated automatically.
Also, you may find useful having a look on the following article:
Have you looked at my video?
There you can se that the issu is that my database is not populated by klicking on the Browse button. If i add SearchDatabase on init the it shows databases,
So this must be an issu with where i should add the eventcode
I see you have the "Refresh the current dialog" event before "ShowDatabases" event. Can you move the "Refresh the current dialog" event after the "ShowDatabases" and see if this fixes your problem?
Indeed, after having a look on your project, it seems that the "Refresh the current dialog" event is scheduled before the "ShowDatabases" event. As Nicolae suggested, can you please schedule the "Refresh the current dialog" after the "ShowDatabases" event and let us know if that helps?
I tryed to change order and it still wont work.
Now the "Published Event" has to records
1. Execute CustomAction, ShowDatabases, 1
2. Refresh the current dialog, 1, 1
This is from the log fil. As you can se it recives databases efter pressing the button [...]
MSI (c) (A4:A0) [16:15:18:240]: Doing action: AI_DATA_SETTER_5
Action 16:15:18: AI_DATA_SETTER_5.
Action start 16:15:18: AI_DATA_SETTER_5.
Action ended 16:15:18: AI_DATA_SETTER_5. Return value 1.
MSI (c) (A4:A0) [16:15:18:256]: Doing action: ShowDatabases
Action 16:15:18: ShowDatabases.
Action start 16:15:18: ShowDatabases.
MSI (c) (A4:2C) [16:15:18:256]: Invoking remote custom action. DLL: C:\Users\ADMINI~1.SEQ\AppData\Local\Temp\2\MSI613D.tmp, Entrypoint: ShowDatabases
MSI (c) (A4!A4) [16:15:18:303]: PROPERTY CHANGE: Deleting SqlServerDatabases property. Its current value is 'AG,Application_Registry_Service_DB_0d51cd1f370d434eb9dc371bb8d87a7b,Bdc_Service_DB_32651a7e4caf4c69b1ca8a7a2d526743,Citrix_Xendesktop7,ERP,Gosta,LastPlan,Managed Metadata Service_e1d1db838dc8497c82b3f910ee2c79cb,master,MLGodasidor,MLGodasidor_stage,model,msdb,PerformancePoint Service Application_ad1b6f10f3a6492b94e465a004c600ad,ProjectServer_Archive,ProjectServer_Draft,ProjectServer_Published,ProjectServer_PWA,ProjectServer_Reporting,QPStage,QuickPickOneNevotex,ReportServer,ReportServerTempDB,Search_Service_Application_CrawlStoreDB_c8a0f859edd44d8e9aeb98463e573d63,Search_Service_Application_DB_e32fd71e702242e99b00612d73d64a08,Search_Service_Application_PropertyStoreDB_ba33b0ade38e4f608312656eaff6ee67,Secure_Store_Service_DB_3f7ead5643684fcea2443676abc6ee75,SessionStateService_60fb146a2aee49b5a894e85fc082449f,SessionStateService_adb21db8670b448c8ec519a325508b5f,SharePoint_AdminContent_6ee50ce3-ef55-47e3-b872-21a2014481fc,SharePoint_AdminContent_cebccc7d-766f-49e4-adec-d49a7cae
MSI (c) (A4!A4) [16:15:18:443]: PROPERTY CHANGE: Adding SqlServerDatabases property. Its value is 'AG,Application_Registry_Service_DB_0d51cd1f370d434eb9dc371bb8d87a7b,Bdc_Service_DB_32651a7e4caf4c69b1ca8a7a2d526743,Citrix_Xendesktop7,ERP,Gosta,LastPlan,Managed Metadata Service_e1d1db838dc8497c82b3f910ee2c79cb,master,MLGodasidor,MLGodasidor_stage,model,msdb,PerformancePoint Service Application_ad1b6f10f3a6492b94e465a004c600ad,ProjectServer_Archive,ProjectServer_Draft,ProjectServer_Published,ProjectServer_PWA,ProjectServer_Reporting,QPStage,QuickPickOneNevotex,ReportServer,ReportServerTempDB,Search_Service_Application_CrawlStoreDB_c8a0f859edd44d8e9aeb98463e573d63,Search_Service_Application_DB_e32fd71e702242e99b00612d73d64a08,Search_Service_Application_PropertyStoreDB_ba33b0ade38e4f608312656eaff6ee67,Secure_Store_Service_DB_3f7ead5643684fcea2443676abc6ee75,SessionStateService_60fb146a2aee49b5a894e85fc082449f,SessionStateService_adb21db8670b448c8ec519a325508b5f,SharePoint_AdminContent_6ee50ce3-ef55-47e3-b872-21a2014481fc,SharePoint_AdminContent_cebccc7d-766f-49e4-adec-d49a7cae78d3,Share
Action ended 16:15:18: ShowDatabases. Return value 1.
This is a strange behavior, indeed. I am not sure why this happens. In order for me to have a better view on this, could you please send me a copy of your .AIP file (project file) by e-mail at support at advancedinstaller dot com?
After further investigating this, I was able to reproduce your scenario. This seems indeed to be an issue in what regards Advanced Installer and it is probably caused (from what I could've seen) by our bootstrapper (EXE Setup).
I have forwarded this to the development team and hopefully it will be fixed in a future version of Advanced Installer. Unfortunately, I can not give you any estimation on when this will be fixed, but I will update this thread as soon as this issue will be fixed.
As a workaround, you can try to use the "Single MSI (resources inside)" package type instead of "Single EXE setup (resources inside)". To change your package type, you can go to "Builds" page.
Unfortunately, this was not fixed in our latest update, but I have increased its priority and hopefully it will be fixed in a future version of Advanced Installer.
However, I am afraid that I can not give you any estimation on when this will be fixed.