SubZero
Posts: 63
Joined: Mon Mar 14, 2011 10:29 am

Test ODBC Connection -> custom action missing

Hi AI-Team,
I have updated from 16.6.1 to 17.3. Now it seems that the custom ui action Test ODBC Connection is gone. Is there a new way to implement this feature or was it mistakenly deleted?
Catalin
Posts: 7845
Joined: Wed Jun 13, 2018 7:49 am

Re: Test ODBC Connection -> custom action missing

Hello,

Lately we have done some improvements in what regards our "Test ODBC Connection" custom action and you are, indeed, right, the custom action itself is now gone from the "Custom Actions" view (you can no longer add it).

Please note that this is the expected behavior.

In order to add a new "Test ODBC Connection" custom action, please go to "SQL Databases" view and press the "Test SQL Connection" button from the toolbar.

After doing so, the custom action will be added in the "Custom Action" view.

Hope this helps.

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
SubZero
Posts: 63
Joined: Mon Mar 14, 2011 10:29 am

Re: Test ODBC Connection -> custom action missing

The new Action is not working for me. Unfortunately the documentation still suggests the old way which is not possible anymore. Is there a sample project where I can see how to get this to work properly?
Catalin
Posts: 7845
Joined: Wed Jun 13, 2018 7:49 am

Re: Test ODBC Connection -> custom action missing

Hello,

To be fully honest with you, I can not say for sure why this happens.

The custom action is exactly the same as it was previously, the only change being that it was removed from the "Custom Actions" page.

Could you please be a little bit more specific about what exactly is not working with the new custom action?

I have done some tests and everything worked as expected on my end.

Here are the steps that I took:

1. "Dialogs" page --> add the "SqlConnectionDlg"

2. "Sql Databases" page --> add a "Predefined Connection"

3. "Sql Databases" page --> add a "Test SQL Connection"

4. "Sql Databases" page --> add a "Browse SQL Servers"

Opt: the "Browse Type" for the SQL Servers Browse is set to "Local SQL Browse"

5. "Custom Actions" page --> "Existing Custom Actions" tab --> right click on each custom action --> "Sequence" --> "Without Sequence" (so we can trigger them from a dialog control)

6. "Dialogs" page --> "SqlConnectionDlg" --> "Next" button --> under "Published Events" --> add two new events that will execute the custom actions:

ca.png
ca.png (171.5 KiB) Viewed 7042 times

This is pretty much it. Hopefully, I did not miss any step.

Also, for your reference, please find attached below the .AIP file in which the above instructions are implemented:
Your Application.aip
(17.46 KiB) Downloaded 340 times
Hope this helps.

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
SubZero
Posts: 63
Joined: Mon Mar 14, 2011 10:29 am

Re: Test ODBC Connection -> custom action missing

First of all thank you very much for taking the time to create that project and give a detailed explanation, that helped a lot!

It works now, but the error handling changed a lot if I am not mistaken. So in the old version if the credentials were bad for example there was an error window giving hints regarding the problem. The new version does not give any hints. Is it possible to get the old error handling back in order to give the user hints regarding the problem?
Catalin
Posts: 7845
Joined: Wed Jun 13, 2018 7:49 am

Re: Test ODBC Connection -> custom action missing

Hello,

You are always welcome! I am really glad I was able to help.

In what regards your new problem, could you please proceed as it follows:

- go to "SQL Databases" page

- select your connection

- check the following option:
Show the "Please Wait..." message box
from under the "Verbose" section.

Hope this helps!

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

Return to “Common Problems”