SuperDev
Posts: 10
Joined: Thu Oct 13, 2022 5:38 pm

Custom SQL Connection Executing Query Before Dialog Box

Mon Dec 05, 2022 6:13 pm

Hello,

I have recently been experiencing issues when executing a package that queries a database on install. I want to dynamically enter the SQL authentication credentials by capturing the user input, which then, uses that information to create a table in that database. However, when I execute the file it just immediately starts querying the database and returns a timeout error (due to no credentials being entered). If possible, could support walk me through this issue via voice chat? Thank you and looking forward to your response!

Catalin
Posts: 6542
Joined: Wed Jun 13, 2018 7:49 am

Re: Custom SQL Connection Executing Query Before Dialog Box

Tue Dec 06, 2022 6:19 pm

Hello and welcome to our forums,

I'm afraid we do not offer live support here due to the difficulty level our tickets have (they require a lot of research, testing).

If possible, could you please create a sample project that reproduces your issue and forward that to me? You can do that either here or by email at support at advancedinstaller dot com.

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

SuperDev
Posts: 10
Joined: Thu Oct 13, 2022 5:38 pm

Re: Custom SQL Connection Executing Query Before Dialog Box

Tue Dec 06, 2022 9:03 pm

Absolutely, will do thank you!

SuperDev
Posts: 10
Joined: Thu Oct 13, 2022 5:38 pm

Re: Custom SQL Connection Executing Query Before Dialog Box

Tue Dec 06, 2022 10:28 pm

Hello Catalin, I have uploaded the requested file please let me know if anything else is needed from me. Thank you so much!
Attachments
Custom SQL.aip
(20.6KiB)Downloaded 112 times

Catalin
Posts: 6542
Joined: Wed Jun 13, 2018 7:49 am

Re: Custom SQL Connection Executing Query Before Dialog Box

Fri Dec 09, 2022 2:07 pm

Hello,

Thank you very much for the sample project!

I have had a look over it and the reason why your setup tries to run the query really soon is because that's how you scheduled it :) .

If you go to "SQL" page, select your query and click on the "Schedule Action" hyperlink, that will lead you to "Custom Actions" page, where your query is scheduled.
Screenshot_32.png
Screenshot_32.png (23.59KiB)Viewed 5249 times

If you do so, you can see that your query is scheduled right after the "Searches" action group. That is exactly when your setup starts.

If you'd like it to be scheduled after the dialogs, you can schedule it after the "User Selection" action group in the "Wizard Dialogs Stage".

Hope this helps!

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

SuperDev
Posts: 10
Joined: Thu Oct 13, 2022 5:38 pm

Re: Custom SQL Connection Executing Query Before Dialog Box

Tue Dec 20, 2022 6:26 pm

Super helpful, thank you so much! Take care!

Catalin
Posts: 6542
Joined: Wed Jun 13, 2018 7:49 am

Re: Custom SQL Connection Executing Query Before Dialog Box

Wed Dec 21, 2022 11:36 am

You're always welcome!

Glad I could help.

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”