Multi-Protocol MasterOPC Server > Lua 5.1 Reference Manual > Function library > The ODBC Library

The ODBC library provides interaction with various DBMSs (MS SQL, Oracle, PostgreSQL, MySQL and others) using an ODBC connector.

Note. Functions to operate via ODBC are available only if the User Script U plugin is installed.

Note. ODBC (Open Database Connectivity) - a program interface to access DBs of Microsoft. That interface allows you to unify connections to various databases from applications.

For proper operation, an ODBC connector must be installed and configured. The respective ODBC connector is provided by a DBMS manufacturer or exterior developers.

Note. Regardless of a type of OS and DBMS, a 32-bit version of an ODBC connector must be used.

For interaction with databases via ODBC in MasterOPC, Lua functions of the section odbc are used. Initially, an ODBC connector must be configured using standard administration environment of Windows.

The OPC server includes two configurations that are examples of operation of odbc functions: demo_odbc and ODBC Example.