You can modify the connection string used for a control path as needed. You can change either the OLE DB Provider or the authentication. For example, you can allow the user the ability to update the password used to connect to the database.
To modify the current database connection for a control path: