SQL Logger Group Tag Type Properties: Settings Tab
The Settings tab holds the properties required to connect this tag to a database.
(Click title to expand text)
As described in SQL Logger Group Tag: Before you begin, you must create and configure a database before using the SQL Logger Group tag.
The DSN (Data Source Name) must already exist on your system and be pointing to the database you created for this tag.
Tell VTS what type of database you are writing to.
CAUTION: The Database Type selection MUST match your database. Choosing an incompatible type will result in the tag failing to write values to your database due to differences in data format.
Auto Delete Records Older Than (Days)
Allows you to limit the size of the database by automatically deleting records older than (n) days.
You may choose to set this value to 0 to turn off the auto-delete feature.
The Username and Password fields should match whatever is required to connect to your database. If you are using MS Access and did not configure a user name and password, then you may leave these fields blank.
Tag ID Table Name, Tag Data Table Name
The two table name fields should not be changed under ordinary circumstances. The database configuration utility supplied with VTS/VTScada created these table names for you by default. (see SQL Logger Group Tag: Before you begin)