Issue
In Designer, when going to the Manage Data Connections window > Add Connection and selecting the "Other" from the drop-down menu; after typing in a Name and the connection string, clicking on the Save button seems to do nothing. The screen just stays there. Able to click on Cancel but in any case, the connection never gets created.
Environment Details
- Alteryx Designer
- Any Database
- Any Database connection string
Cause
A glitch in the GUI does not initiate the connection string to be saved.
Resolution
After typing in the name and the connection string in the appropriate fields, ensure to click the small drop-down arrow to the right of the Connection String field to invoke the drop-down menu. However no need to select an option from the menu, simply click away and the Save feature will function.
Note
If the System option in the
Type drop-down menu is not available or grayed out, Designer must be closed and re-opened using the "Run as Administrator" option.
Additional Resources