FLOWCAL Database Connection

FLOWCAL Database

The FLOWCAL Database connection is used by the asiFlowCalScadaRequest Service which monitors the FLOWCAL database for GC Write Request processing.

Provider

The database provider: Microsoft (MSORADB), Oracle or Custom.  Note: The 32-bit version of the Oracle client is required for the 32-bit version of ACM.

Database name

The name of the FLOWCAL database to be used.

Authentication/User name/Password

The authentication information required for secure access to the database. 

Custom

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

Provider=OraOLEDB.Oracle.1;Data Source=FCPROD;User Id=User1;Password=Pwd;UseSessionFormat = TRUE; 

FCPROD = 
     (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = VMFLOWCAL2)(PORT = 1521))
          (CONNECT_DATA =
                 (SERVER = DEDICATED)
                 (SERVICE_NAME = FLOWCAL)
           )
      )

Test Connection

Use this to confirm that the authentication information is correct.  The Windows Authentication option will attempt to connect under the asiFlowCalScadaRequest user account.

Test Connection as User

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

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