Database Configuration

This chapter contains some examples of how to configure the parameters needed to access external databases

Configuring MYSQL, MariaDB and PostgreSQL databases

Parameter Description
Name Define the name to use to reference the database defined in this item.
Type

Select: ODBC

IPAddress Server IP Address
Port Port used from MSSQL Server (generally 1433)
Username Username for accessing the MSSQL database
Password Password for accessing the MSSQL database
Database The name of the database you want to access
Description This is just a reminder (write here what you prefer)
Configuring ODBC on JMobile PC Runtime

Open Database Connectivity offers different types of connections

Accessing to Microsoft databases using MSSQL Server

Parameter Description
Name Define the name to use to reference the database defined in this item.
Type

Select: ODBC

IPAddress Server IP Address
Port Port used from MSSQL Server (generally 1433)
Connection Type Select: Driver
ODBC Database Select: MSSQL Server
Driver Name Type a driver name installed on Windows PC: "ODBC Driver 17 for SQL Server"
Username Username for accessing the MSSQL database
Password Password for accessing the MSSQL database
Database The name of the database you want to access
Description This is just a reminder (write here what you prefer)
Accessing to Microsoft databases using MSSQL Server and DSN

Parameter Description
Name Define the name to use to reference the database defined in this item.
Type

Select: ODBC

Connection Type Select: DSN
DSN Select the DSN to use
ODBC Database Select: MSSQL Server
Username Username for accessing the MSSQL database
Password Password for accessing the MSSQL database
Description This is just a reminder (write here what you prefer)
Accessing to an internal "MS Access" file

Parameter Description
Name Define the name to use to reference the database defined in this item.
Type

Select: ODBC

Connection Type Select: Driver
ODBC Database Select: MS Access
Driver Name Type a driver name installed on your PC, generally: "Microsoft Access Driver (*.mdb)"
MS AccessFile Type the MS Access file to use
Description This is just a reminder (write here what you prefer)
Accessing to an internal "MS Access" file using DSN

Parameter Description
Name Define the name to use to reference the database defined in this item.
Type

Select: ODBC

Connection Type Select: DSN
DSN Select the DSN to use
ODBC Database MS Access
Description This is just a reminder (write here what you prefer)
Configuring DSN on Windows PC

The "ODBC Data Source Administrator" system tool can be used to configure DSN elements or to retrieve the installed driver names.

  1. Name of the DSN element

  2. Driver name to type using "MS Access"

  3. Driver name to type using "MSSQL Server"

Configuring ODBC on JMobile HMI Runtime

Open Database Connectivity offers different types of connections

Accessing to Microsoft databases using MSSQL Server

Parameter Description
Name Define the name to use to reference the database defined in this item.
Type

Select: ODBC

IPAddress Server IP Address
Port Port used from MSSQL Server (generally 1433)
Connection Type Select: Driver
ODBC Database Select: MSSQL Server
Driver Name Type a driver name installed on the HMI device: "libtdsodbc.so.0"
Username Username for accessing the MSSQL database
Password Password for accessing the MSSQL database
Database The name of the database you want to access
Description This is just a reminder (write here what you prefer)
Accessing to Microsoft databases using MSSQL Server and DSN

This is a special configuration, for advanced users only, which requires the modification of internal files of the HMI device

Parameter Description
Name Define the name to use to reference the database defined in this item.
Type

Select: ODBC

Connection Type Select: DSN
DSN Select the DSN to use
ODBC Database Select: MSSQL Server
Username Username for accessing the MSSQL database
Password Password for accessing the MSSQL database
Description This is just a reminder (write here what you prefer)
Accessing to an internal "MS Access" file

This configuration is not fully supported on HMI devices. MS Access databases can only be read.

Parameter Description
Name Define the name to use to reference the database defined in this item.
Type

Select: ODBC

Connection Type Select: Driver
ODBC Database Select: MS Access
Driver Name Type a driver name installed on the HMI device: "libmdbodbc.so"
MS AccessFile Type the MS Access file to use
Description This is just a reminder (write here what you prefer)
Accessing to an internal "MS Access" file using DSN

This configuration is not fully supported on HMI devices. MS Access databases can only be read.

This is a special configuration, for advanced users only, which requires the modification of internal files of the HMI device

Parameter Description
Name Define the name to use to reference the database defined in this item.
Type

Select: ODBC

Connection Type Select: DSN
DSN Select the DSN to use
ODBC Database MS Access
Description This is just a reminder (write here what you prefer)
Configuring DSN on HMI device

There are two files of the UnixODBC Driver manager to write and copy to /mnt/data/hmi/qthmi/deploy/data

DNS configuration to support MS SQL Server

odbcinst.ini

[FreeTDS]
Description = v0.91 with protocol v7.2
Driver = /mnt/data/hmi/qthmi/deploy/libtdsodbc.so.0

odbc.ini

[Datasourcename]
Driver = FreeTDS
Description =
Trace =
Server =
Port =
TDS version =
Database =

Example:

DNS configuration to support MS Access

odbcinst.ini

[MDBTools]
Description=MDBTools Driver
Driver=/mnt/data/hmi/qthmi/deploy/libmdbodbc.so

odbc.ini

[MSAccess]
Driver = MDBTools
Description =
Database =
Server =

Example: