Expand | ||||
---|---|---|---|---|
| ||||
|
...
To create a new database, update an existing database or change the database the ACM Configuration client utilizes, click the Manage Database... button.
Server name
The name of the SQL server the database will reside in.
...
Default = Not selected. Select this to use the same connection and authentication for running reports. This information can be later modified in the Reports section of the ACM Monitor if necessary.
Custom Setting
Default = blank. If a custom setting needs to be appended to the connection, e.g. "MultiSubnetFailover=Yes", enter it here. If multiple custom settings are entered, they must be separated by a semi-colon.
Create/Update Database
Click the "Create/Update" Database button in order to either create a new database or update an existing database to the latest version. This will bring up the Create/Update Database Wizard.
...
Click this button to backup the database. The backup is stored with the ACM system files; the default location is "C:\ProgramData\AutoSol\Communication Manager\7".
Info | ||
---|---|---|
| ||
See Backup the ACM database to an emergency Microsoft Access database. |
...
Info | ||
---|---|---|
| ||
Sample setup
Install Oracle client driver files (available from ACM ftp site). Note: The 32-bit version of the Oracle client is required for the 32-bit version of ACM. Custom connection string:Provider=OraOLEDB.Oracle.1;Data Source=FCPROD;User Id=User1;Password=Pwd;UseSessionFormat = TRUE; tnsnames.ora file: FCPROD = |
...