Project properties
Editor for server settings
The Server Settings editor can be used to edit the settings for the TwinCAT Database Server. These are general settings relating to the corresponding server. In the drop-down menu (1) you can select the target system via the Ams NetID. To this end you have to create a route to the target system via TwinCAT. When a finished configuration is transferred, the settings are stored in the TwinCAT Database Server for this target system.
The settings for logging faults or errors can be configured under Log settings. In the event of a fault or error, the Database Server generates a detailed entry in a log file. The log file can be read with the Information Log Viewer. Under Log Settings you can specify a path to the file location and the maximum file size. You can also influence the accuracy of the log. For performance reasons we recommend that logging is deactivated again after the error analysis, once it is no longer required.
For network access to file-based databases such as Access or SQL Compact, the Impersonate option must be set, so that the TwinCAT Database Server can connect to this network drive. This feature is currently not supported in Windows CE.
Further configuration settings are available to control the read process from the database. These settings refer to the TwinCAT Database Server on the target system:
MaxStringLength | Maximum string length of the variables in the PLC |
MaxByteArrayLength | Maximum byte array length of the variables in the PLC |
DBNullAllowed | Indicates whether ZERO values are accepted in the TwinCAT Database Server. |
DBConnectionTimeout | Indicates the time after which the TwinCAT Database Server assumes a connection error while attempts are made to establish a connection. |
DBCommandTimeout | Indicates the time after which the TwinCAT Database Server assumes a connection fault when a command was sent. If large data quantities are involved, processing of a command may take quite some time, depending on the database and the infrastructure. |
Supported database types
The installed database types can be selected in the server settings. All installed databases are selected by default. The TwinCAT 3 Database Server will load the corresponding database interfaces. In this way, unused databases on the target system can be deselected.