Versions Compared

Old Version 2

changes.mady.by.user Michael Standal

Saved on

compared with

New Version 3

changes.mady.by.user kristina schaeffer

Saved on

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.

...

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.

...

Click "Database Statistics" to view and manage database statistics of the ACM database.

Image RemovedImage Added

The top grid shows the current overall status of the ACM database.  This screen is a quick view into the database configuration and how much memory is available.  The sizes listed in this table all are recorded in Megabytes (MB).

...

Storage Stats: Click to view the storage statics for the tables within the ACM database.

Image RemovedImage Added

This form contains the ACM Detail Table which is a comprehensive break down of how much memory each individual table is using in the database. 

...

If ACM will be publishing to a FLOWCAL database, the connection information is entered into the form below.

Image RemovedImage Added

Provider

The database provider: Microsoft (MSORADB), Oracle or Custom.

...

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)
           )
      )

...

Use this to test the connection under a different windows user.  

Image RemovedImage Added

Enter the User name (DOMAIN\User) and password for the user in question.