Online Documentation - Statistics - FAQ - Plugin Parts (All, Dependencies) - Class hierarchy
New in Version 22.2 22.3 22.4 22.5 23.0 23.1 23.2 23.3 23.4 23.5 24.0 24.1
The list of the topics, classes, interfaces, controls, modules, global methods by category, global methods by name, screenshots, licenses and examples.
Platforms to show: All Mac Windows Linux Cross-Platform
Back to SQLDatabaseMBS class.
SQLDatabaseMBS.kOptionLibraryDB2 = "DB2CLI.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for DB2.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the DB2 download on their homepage.
If no value is given, we default to
Windows: db2clio.dll
macOS: libdb2.dylib
Linux: libdb2.so
SQLDatabaseMBS.kOptionLibraryFirebird = "IBASE.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for FireBird (or Interbase).
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the Firebird download on their homepage.
If no value is given, we default to
Windows: ibclient64.dll;fbclient.dll;gds32.dll
macOS: libgds.dylib:libfbclient.dylib
Linux: libgds.so:libfbclient.so
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibraryInformix = "INFCLI.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for Informix.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the Informix download on their homepage.
If no value is given, we default to
Windows: ICLIT09B.DLL;ICLIT09A.DLL
macOS: iclit09b.dylib:iclit09a.dylib:libifcli.dylib
Linux: iclit09b.so:iclit09a.so:libifcli.so
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibraryInterbase = "IBASE.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for FireBird (or Interbase).
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the FireBird download on their homepage.
If no value is given, we default to
Windows: ibclient64.dll;fbclient.dll;gds32.dll
macOS: libgds.dylib:libfbclient.dylib
Linux: libgds.so:libfbclient.so
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibraryMySQL = "MYSQL.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for MySQL (or MariaDB).
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the MySQL download on their homepage or from the Libs folder on our website.
If no value is given, we default to
Windows: libmySQL.dll;libmariadb.dll
macOS: libmysqlclient.dylib.21:libmysqlclient_r.dylib:libmysqlclient_r.18.dylib:libmysqlclient_r.16.dylib:libmysqlclient_r.15.dylib:libmysqlclient.dylib:libmariadb.dylib.3:libmariadb.dylib.2:libmariadb.dylib
Linux: libmysqlclient.so.21:libmysqlclient_r.so:libmysqlclient_r.so.18:libmysqlclient_r.so.16:libmysqlclient_r.so.15:libmysqlclient.so:libmariadb.so.3:libmariadb.so.2:libmariadb.so
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibraryODBC = "ODBC.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for ODBC.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll".
If no value is given, we default to
Windows: odbc32.dll
macOS: libiodbc.dylib:libiodbc.3.dylib:libiodbc.2.dylib:libodbc.dylib
Linux: libiodbc.so:libiodbc.so.3:libiodbc.so.2:libodbc.so:libodbc.so.1
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibraryOracle = "OCI8.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for Oracle.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the Oracle download on their homepage.
If no value is given, we default to
Windows: oci.dll
macOS: libclntsh.dylib
Linux: libclntsh.so
SQLDatabaseMBS.kOptionLibraryPostgreSQL = "LIBPQ.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for PostgreSQL
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the PostgreSQL download on their homepage or from the Libs folder on our website.
If no value is given, we default to
Windows: libpq.dll;pq.dll
macOS: libpq.dylib:libpq.5.dylib
Linux: libpq.so:libpq.so.5:libpq.so.4:libpq.so.3
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibrarySQLanywhere = "SQLANY.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 15.2 |
Tells the plugin where to find the library for SQL Anywhere.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the SQL Anywhere download on their homepage.
If no value is given, we default to
Windows: dbcapi.dll
macOS: libdbcapi_r.dylib
Linux: libdbcapi_r.so
SQLDatabaseMBS.kOptionLibrarySQLBase = "SQLBASE.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for SQLBase.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the SQLBase download on their homepage.
If no value is given, we default to
Windows: sqlwntm.dll
macOS: libsqlbapl.dylib
Linux: libsqlbapl.so
SQLDatabaseMBS.kOptionLibrarySQLite = "SQLITE.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for SQLite. Not needed if you use InternalSQLiteLibraryMBS module!
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the SQLite download on their homepage or from the Libs folder on our website. But normally you'd use the built-in library using InternalSQLiteLibraryMBS module.
If no value is given, we default to
Windows: libsqlite3.dll
macOS: libsqlite3.dylib
Linux: libsqlite3.so
SQLDatabaseMBS.kOptionLibrarySybaseComn = "SYBCOMN.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for Sybase.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the Sybase download on their homepage.
If no value is given, we default to
Windows: libsybcomn.dll:libcomn.dll
macOS: libsybcomn_r.dylib:libcomn_r.dylib
Linux: libsybcomn_r.so:libcomn_r.so
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibrarySybaseCS = "SYBCS.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for Sybase.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the Sybase download on their homepage.
If no value is given, we default to
Windows: libsybcs.dll:libcs.dll
macOS: libsybcs_r.dylib:libcs_r.dylib
Linux: libsybcs_r.so:libcs_r.so
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibrarySybaseCT = "SYBCT.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for Sybase.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the Sybase download on their homepage.
If no value is given, we default to
Windows: libsybct.dll:libct.dll
macOS: libsybct_r.dylib:libct_r.dylib
Linux: libsybct_r.so:libct_r.so
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibrarySybaseIntl = "SYBINTL.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for Sybase.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the Sybase download on their homepage.
If no value is given, we default to
Windows: libsybintl.dll:libintl.dll
macOS: libsybintl_r.dylib:libintl_r.dylib
Linux: libsybintl_r.so:libintl_r.so
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kOptionLibrarySybaseTCL = "SYBTCL.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Tells the plugin where to find the library for Sybase.
The value can contain multiple names and paths separated with ";" on Windows and ":" on macOS/Linux.
The library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the Sybase download on their homepage.
If no value is given, we default to
Windows: libsybtcl.dll:libtcl.dll
macOS: libsybtcl_r.dylib:libtcl_r.dylib
Linux: libsybtcl_r.so:libtcl_r.so
The default is set to work in most cases and try various possible library names.
SQLDatabaseMBS.kAutoCommitOff = 0
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Autocommit is off.
SQLDatabaseMBS.kAutoCommitOn = 1
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Autocommit is on.
SQLDatabaseMBS.kAutoCommitUnknown = -1
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 12.3 |
Autocommit unknown
The items on this page are in the following plugins: MBS SQL Plugin.