Declaration of different database types

Mircosoft SQL Database

-DBValueType:

If you only log alphanumeric data types and Boolean choose "Double".
If you want to log structs and strings too, you must select "Bytes".

-DBType:

You must choose "MS SQL". →PLC: eDBType_Sequal_Server.

-DBServer:

Insert here the Name of the sql-server. e.g. ("TESTSERVER\SQLEXPRESS")

-DBProvider:

"SQLOLEDB" or Provider of the SQL Native Clients e.g., "SQLNCLI10".

-DBName

DBName contains the name of the database.

-DBTable:

DBTable contains the name of the table.

Mircosoft Compact SQL Database

-DBValueType:

If you only log alphanumeric data types and Boolean choose "Double".
If you want to log structs and strings too, you must select "Bytes".

-DBType:

You must choose "MS Compact SQL". →PLC: eDBType_Mobile_Server.

-DBServer:

This option won't be needed.

-DBProvider:

This option won't be needed.

-DBUrl

DBUrl contains the path to the SDF-File. e.g. ("C:\TwinCAT\TcDatabaseSrv\Samples\TestDB.sdf")

-DBTable:

DBTable contains the name of the table.

NET-MySQL Database

-DBValueType:

If you only log alphanumeric data types and Boolean choose "Double".
If you want to log structs and strings too, you must select "Bytes".

-DBType:

You must choose "NET_MySQL". →PLC: eDBType_NET_MySQL.

-ODBC Driver:

This option won't be needed.

-Server name:

Contains the name of the Server or the IP-address of the host.

-Database name:

Contains the name of the database.

-Port:

Contains the port for the connection. (Standard 3306)

-Protocol:

This option won't be needed.

-Scheme:

This option won't be needed.

-Sequence:

This option won't be needed.

-Table name:

Contains the name of the table in which you will read or write.

-UserId:

Contains the name of the user.

-Password:

Contains the password for the authentication.

ASCII - File

-DBValueType:

If you only log alphanumeric data types and Boolean choose "Double".
If you want to log structs and strings too, you must select "Bytes".

-DBType:

You must choose "ASCII". →PLC: eDBType_ASCII.

-DBServer:

This option won't be needed.

-DBProvider:

This option won't be needed.

-DBUrl

DBUrl contains the path to the ASC-File oder TXT-File or CSV-File. e.g. ("C:\TwinCAT\TcDatabaseSrv\Samples\TestDB.asc")

-DBTable:

This option won't be needed. No table could be declare in ASCII-Files.

XML Database

-DBValueType:

If you only log alphanumeric data types and boolean choose "Double".
If you want to log structs and strings too, you have to select "Bytes".

-DBType:

You have to choose "XML"ðPLC: eDBType_XML.

-DBServer:

Contains the name of the database

-DBProvider:

This option won't be needed.

-DBUrl

DBUrl contains the path to the XML-file. e.g. ("C:\TwinCAT\TcDatabaseSrv\Samples\TestDB.xml")

The XSD-file have to be in the same directory and must have the same file name. e.g. ("C:\TwinCAT\TcDatabaseSrv\Samples\TestDB.xsd")

-DBTable:

Contains the name of the table in which you will read or write.