Declaration of the different database types
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |
-DBValueType: | If you only log alphanumeric data types and Boolean choose "Double". |
-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. |