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 SQLConnectionMBS class.
SQLConnectionMBS.kANSILevel0 = 0
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
ANSI Level 0
SQLConnectionMBS.kANSILevel1 = 1
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
ANSI Level 1
SQLConnectionMBS.kANSILevel2 = 2
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
ANSI Level 2
SQLConnectionMBS.kANSILevel3 = 3
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
ANSI Level 3
SQLConnectionMBS.kLevelUnknown = -1
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Unknown
SQLConnectionMBS.kReadCommitted = 1
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Read committed.
SQLConnectionMBS.kReadUncommitted = 0
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Read uncommitted.
SQLConnectionMBS.kRepeatableRead = 2
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Repeatable read.
SQLConnectionMBS.kSerializable = 3
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Serializable.
SQLConnectionMBS.kSnapshot = 4
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 21.2 |
Changes made in other transactions can not be seen. For Microsoft SQL Server.
SQLConnectionMBS.kOptionLibraryDB2 = "DB2CLI.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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
SQLConnectionMBS.kOptionLibraryFirebird = "IBASE.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kOptionLibraryInformix = "INFCLI.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kOptionLibraryInterbase = "IBASE.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kOptionLibraryMySQL = "MYSQL.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kOptionLibraryODBC = "ODBC.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kOptionLibraryOracle = "OCI8.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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
SQLConnectionMBS.kOptionLibraryPostgreSQL = "LIBPQ.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.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
SQLConnectionMBS.kOptionLibrarySQLBase = "SQLBASE.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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
SQLConnectionMBS.kOptionLibrarySQLite = "SQLITE.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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
SQLConnectionMBS.kOptionLibrarySybaseComn = "SYBCOMN.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kOptionLibrarySybaseCS = "SYBCS.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kOptionLibrarySybaseCT = "SYBCT.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kOptionLibrarySybaseIntl = "SYBINTL.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kOptionLibrarySybaseTCL = "SYBTCL.LIBS"
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.5 |
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.
SQLConnectionMBS.kClientNotSpecified = 0
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Client is not specified.
SQLConnectionMBS.kCubeSQLClient = 13
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 18.0 |
CubeSQL client. (coming soon)
SQLConnectionMBS.kDB2Client = 6
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
DB2 client.
SQLConnectionMBS.kDuckDBClient = 14
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 21.2 |
DuckDB client
SQLConnectionMBS.kFirebirdClient = 4
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 10.4 |
InterBase/Firebird client.
SQLConnectionMBS.kInformixClient = 7
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Informix client.
SQLConnectionMBS.kInterBaseClient = 4
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
InterBase/Firebird client.
SQLConnectionMBS.kMariaDBClient = 15
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 22.3 |
MariaDB client.
SQLConnectionMBS.kMySQLClient = 9
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
MySQL or MariaDB client.
SQLConnectionMBS.kODBCClient = 1
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
ODBC client.
SQLConnectionMBS.kOracleClient = 2
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Oracle client.
For Windows the file is "oci.dll", for Linux libclntsh.so and for Mac OS X libclntsh.dylib.
SQLConnectionMBS.kPostgreSQLClient = 10
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
PostgreSQL client.
SQLConnectionMBS.kSQLAnywhereClient = 12
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 18.0 |
SQL Anywhere client.
SQLConnectionMBS.kSQLBaseClient = 5
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
SQLbase client.
SQLConnectionMBS.kSQLiteClient = 11
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
SQLite client. Or spatialite.
SQLConnectionMBS.kSQLServerClient = 3
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Mircosoft SQL Server client.
You may need to download the client packages for accessing SQL Server. Files like the SQLNCLI dll may be missing. You can download for example the Feature Pack for Microsoft SQL Server 2005 from the microsoft download page.
SQLConnectionMBS.kSybaseClient = 8
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Sybase client.
SQLConnectionMBS.kAutoCommitOff = 0
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Autocommit is off.
SQLConnectionMBS.kAutoCommitOn = 1
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Autocommit is on.
SQLConnectionMBS.kAutoCommitUnknown = -1
Type | Topic | Plugin | Version |
const | SQL | MBS SQL Plugin | 9.3 |
Autocommit unknown
The items on this page are in the following plugins: MBS SQL Plugin.