When creating a new database connection, it's best practice to name the new dbc file with the database name. For example, aresdata.dbc or cc211.dbc.
The reason for renaming the dbc file with the database name versus logon.dbc stems from how the default is chosen in the SQL Alias Manager (SAM). If there are multiple DBC files, the SAM follows a specific order of operations when locating the database connection. As soon as it locates a dbc file, that file will be utilized despite the default set in the SAM. Please see the sequence below for how the DBC connection file is chosen:
- The application looks for the logon.dbc file that exists in the root of the application directory for the executing application. Prior to Ares 5.0, this path is C:\Program Files (x86)\Ares\. For Ares 5.0, the path will differ based on whether the Client was installed per-machine or per-user:
- The default application directory for a per-machine install is C:\Program Files (x86)\Ares\
- The default application directory for a per-user install is %USERPROFILE%\AppData\Local\Apps\Ares\Client\
- Then, it looks for the dbc specified by the current user registry settings– Current User\Software\AtlasSystems\Ares\LogonSettingsPath
- Note- This location is set by assigning a "Current User" default in the SAM
- Next, it looks for the dbc specified by the local machine registry settings – Local Machine\Software\AtlasSystems\Ares\LogonSettingsPath
- Note- This location is set by assigning a "Local Machine" default in the SAM
- Finally, the SAM checks the legacy install paths– C:\Ares\Logon.dbc
Even if you create a new logon.dbc file and set it as default, it will not become the new priority. This is why we suggest an alternative naming system. If you were to name a new dbc file logon.dbc and place it in the same directory as another logon.dbc file, you will override any defaults set in the SAM. This adversely impacts the specific application based upon which directory the file resides in. For example, if you were to place the file in C:\Program Files(x86)\Ares it would affect the Client because that is the Client directory; however, it would have no impact on the Customization Manager if that application is in another directory.
Essentially, if the dbc file utilizes the database name instead of logon.dbc, the SAM's order of operations will not override the new default of database name.dbc and that file will remain a priority as per the default settings.