Declaration of the 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.

Microsoft Access 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 Access". →PLC: eDBType_Access.

-DBServer:

This option won't be needed.

-DBProvider:

For Access 2000 - Access 2003: The provider is "Microsoft.Jet.OLEDB.4.0".
For Access 2007: The provider is "Microsoft.ACE.OLEDB.12.0".

-DBUrl

DBUrl contains the path to the MDB-File. E.g.("C:\TwinCAT\TcDatabaseSrv\Samples\TestDB.mdb")

-DBTable:

DBTable contains the name of the table.

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 declared in ASCII-Files.

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.

ODBC-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 "ODBC_MySQL". →PLC: eDBType_ODBC_MySQL.

-ODBC Driver:

Insert the name of the ODBC-driver. ("MySQL ODBC 3.51 Driver")

-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 ODBC - connection

-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.

ODBC-PostgreSQL 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 "ODBC_PostgreSQL". →PLC: eDBType_ODBC_PostgreSQL.

-ODBC Driver:

Insert the name of the ODBC-driver. ("PostgreSQL UNICODE")

-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 ODBC - connection

-Protocol:

This option won't be needed.

-Scheme:

Contains the name of the used scheme.

-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.

ODBC-DB2 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 "ODBC_DB2". →PLC: eDBType_ODBC_DB2.

-ODBC Driver:

Insert the name of the ODBC-driver. ("IBM DB2 ODBC DRIVER")

-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 ODBC - connection

-Protocol:

Contains the name of the used protocol (TCPIP).

-Scheme:

Contains the name of the used scheme.

-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.

OCI-Oracle Database (Oracle Calling Interface)

-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 "OCI_Oracle". →PLC: eDBType_OCI_Oracle.

-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 / service name.

-Port:

Port for the connection (default:1521)

-Protocol:

Protocol for the connection (default: TCP)

-Scheme:

Contains the name of the used scheme.

-Sequence:

Contains the name of the used sequence.

-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.

ODBC-Oracle 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 "ODBC_Oracle". →PLC: eDBType_ODBC_Oracle.

-ODBC Driver:

Insert the name of the ODBC-driver. ("Microsoft ODBC for Oracle")

-Server name:

This option won't be needed. (Only local connection)

-Database name:

Contains the name of the database.

-Port:

This option won't be needed.

-Protocol:

This option won't be needed.

-Scheme:

Contains the name of the used scheme.

-Sequence:

Contains the name of the used sequence.

-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.

ODBC-InterBase 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 "ODBC_InterBase". →PLC: eDBType_ODBC_InterBase.

-ODBC Driver:

Insert the name of the ODBC-driver. ("Firebird/InterBase(r) driver")

-Server name:

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

-Database name:

Contains the name of the database.

-ClientDll:

Contains the path to the fbclient.dll.

-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.

ODBC-Firebird 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 "ODBC_Firebird". →PLC: eDBType_ODBC_Firebird.

-ODBC Driver:

Insert the name of the ODBC-driver. ("Firebird/InterBase(r) driver")

-Server name:

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

-Database name:

Contains the name of the database.

-ClientDll:

Contains the path to the fbclient.dll.

-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.

XML 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 "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 must 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.