Firebird

This section contains information on the configuration and the data type mapping of Firebird databases with ODBC.

Declaration in the TwinCAT Database Server Configurator

ODBC Firebird database

Database Type

"Odbc_Database"

ODBC Type

Select "Firebird" from the drop-down menu.

Driver

Select here the actually installed driver.

Database

Enter the name of the database.

Client

 

Uid

Enter the user name here.

Pwd

Enter the corresponding password.

Data type mapping between DB and PLC

E_ColumnTypes

Firebird

TwinCAT PLC

BigInt

BIGINT

T_ULARGE_INTEGER (TcUtilities.lib)

Integer

INTEGER

DINT

SmallInt

SMALLINT

INT

TinyInt

TINYINT

INT

Bit_

CHAR(1)

STRING

Money

DECIMAL(18,4)

LREAL

Float

FLOAT

REAL

Real_

DOUBLE PRECISION

LREAL

DateTime

TIMESTAMP

DT

NText

VARCHAR(254)

STRING

NChar

CHAR(254)

STRING

Image

BLOB

ARRAY OF BYTE

NVarChar

VARCHAR(254)

STRING

Binary

BLOB

ARRAY OF BYTE

VarBinary

BLOB

ARRAY OF BYTE

Firebird 1:

Data type support

WSTRING is not supported by this database. (See WString support)

Firebird 2:

Functioning

All functions of the TwinCAT Database Server can be applied to the ODBC templates. This does not apply to the "Free Connection String".

Notice

Data security

In flash memory devices the number of write access operations is limited. The flash memory devices can fail, with a risk of data loss.

  • Make regular backups of your system. Use the IPC diagnostics in order to determine the status of the flash memory devices.