Versions Compared

Old Version 8

changes.mady.by.user Emma Fullilove (Deactivated)

Saved on

compared with

New Version 9

changes.mady.by.user Emma Fullilove (Deactivated)

Saved on

Key

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


Expand
titleTable Of Contents

Table of Contents
printablefalse

...

Info

If opting to use Database Authentication, user name and password must conform to Microsoft’s guidelines found at: https://docs.microsoft.com/en-us/sql/relational-databases/security/strong-passwords?view=sql-server-ver15.  Passwords must not contain the following characters: [] () , ; ? * ! @ =.  as they are reserved characters in ODBC connections. (See note concerning the use of ODBC connection strings).


Azure Database

Default = Not selected. Select this if the database is an Azure database as ACM may not run properly otherwise.

...

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.

...

If opting to use authentication, user name and password must conform to Microsoft’s guidelines found at: https://docs.microsoft.com/en-us/sql/relational-databases/security/strong-passwords?view=sql-server-ver15 (See note concerning the use of ODBC connection strings).

Custom

If using a Custom provider, enter the custom or provider-specific connection string.

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

...