DBMS Settings for Recording data on DataBase

Some parameters which are used for DBMS links are always the same ones used, independently whether recording a Historical Log, a Data Logger, variable tracing, etc. These parameters are described below:

 

 

Keep the DB Connection open

This property, when enabled, allows the ODBC connection to be kept open and used for all the transactions to be executed. When the property is disabled, the ODBC connection will be opened when a transaction is requested and then closed again.

 

We suggest you disable the 'Recycle DB Connection' property only when recording is less frequent.

 

Max. Error Number

The highest number of DBMS errors allowed after which the connection is considered not valid and data is saved on files in ASCII format ("DLOGGERS", "LOGS", "DATA").

 

See paragraph relating to "File del Progetto" for  ".TraceDBEx", ".DataLoggerEx" and ".HisLogEx" file types.

 

Max. Transitions

Maximum number of transitions per cycle to be updated before closing.

 

Max. Cache Size

This setting allows you to set the Cache's maximum size before they system loads data on file.  The number is set in Bytes.

 

Max. VarChar Precision

This setting allows the maximum precision to be set for the string type columns.  The set number represents the number of string characters.

 

ODBC DSN

This setting allows you to set a customized ODBC connection.  Movicon will create a file in Access2000 format in the project's 'LOGS' folder for default with the name:

 

ProjectName_HisLog.mdb

 

However you can also customize the ODBC connection through this property, creating a different data base from that of Access2000 with a different name.

 

Unfortunately the ODBC Manager does not pass on any information about the name of the any created connections. Therefore the procedure requires that the name of the connection be inserted first so that Movicon can pass it over to the ODBC Manager. The name of the connection can also be inserted after it has been created. In any case the name of the connection has to be typed in the box manually.

 

ODBC DSN User

This property specifies the users name to be used for the  ODBC connection.

 

 

See Also