Option 2.6.2. Logging Connection Selected for a Single Table

Select the Connection tab.

Configuration is as follows.

1

Use default point logging.

2

Connection information

3

Store and forward

 

1

Use default point connection

Clear Use default point connection.

The Connection tab is enabled to enter specifications for the selected table.

2

Connection information

The connection information enables you to select an ODBC data source that is different from the default.

Connection options

ODBC data source selection procedures.

Connection Options

Field

Description

ODBC data source

An ODBC data source can be:

 

A

Selected from the field's drop-down list

 

B

A re-configured existing source or a new ODBC data source.

Database user

User who will connect to the selected database driver.

Important: This field is required if you are connecting to a SQL Server.

Password

Needed to connect to the selected database driver.

Important: This field is required if you are connecting to a SQL Server

Reconnect wait period

A value between 0 (continuous retries) and 24 hours.

This value specifies the amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost.

Time unites include:

Seconds

Minutes

Hours

 

Default

30 seconds.

ODBC data source selection procedures

  1. Select an ODBC data source from the drop down list in the ODBC data source, field. You can select from available options or configure an existing or a new ODBC data source:

Basic options include, but are not limited to:

Selection

 SQL Server is:

Logs to:

CIMPLICITY Logging - Alarms

Installed

SQL Server database

 

Not installed

cimplog.mdb in the

...\Proficy CIMPLICITY\ARC directory

CIMPLICITY Logging - Points

Installed

SQL Server database

 

Not installed

pointlog.mdb in the

...\Proficy CIMPLICITY\ARC directory  

Note: If you have an Oracle database, you may see the ODBC data source that you created for Oracle.

  1. Configure an existing or add a new ODBC data source.

  1. Click the ODBC Data Source button to the right of the ODBC data source field.

The ODBC Data Source Administrator opens.

  1. Select the System DSN tab.

  1. Configure the new ODBC data source based on the data source procedures.

  2. Close the ODBC Data Source Administrator.

  3. Select the new ODBC data source from the drop down menu.

3

Store and forward

When Enable store and forward is checked the DATA_LOG will perform store and forward functions.

Options are:

Option

Description

No Limit

Checked enables No Limit.

The Database Logger will store an unlimited number of records when its connection to the database is down.

The number of records actually stored is determined by the amount of time the connection is lost and by the amount of free disk space you have.

Max number of stored records

The Database Logger will store a specified number of records when its connection to the database is down.

Enter a number between 1 and 4294967285.

 

Checked

Enables Max number of stored records.

 

Field

Number that will be the maximum stored.

Valid numbers are from 1 to 4294967285.

More information

Step 2.6. Configure the logging connection.