This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Any Database connection string
A glitch in the GUI does not initiate the connection string to be saved.
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.
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.