Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Expand
titleTable Of Contents

Table of Contents
printablefalse

...

To create a new database, update an existing database or change the database the ACM Configuration client utilizes, click the Manage Database... button.  

Image RemovedImage Added

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
titleBackup Now Note

See Backup the ACM database to an emergency Microsoft Access database.

...

Info
titleOracle Connection Example

Sample setup

  • FCPROD is the name of the listener on the FLOWCAL machine.
  • VMFLOWCAL2 is the name of the FLOWCAL machine.
  • FLOWCAL is the name of the FLOWCAL database.

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 = 
     (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = VMFLOWCAL2)(PORT = 1521))
          (CONNECT_DATA =
                 (SERVER = DEDICATED)
                 (SERVICE_NAME = FLOWCAL)
           )
      )

...