SQLDatabaseMBS constants

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.

Options to specify the library with SetFileOption

SQLDatabaseMBS.kOptionLibraryDB2 = "DB2CLI.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.
Example
dim con as SQLDatabaseMBS // your database connection

dim f as FolderItem = GetFolderItem("sqlite.dylib")
con.SetFileOption con.kOptionLibrarySQLite, f

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
OOne of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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
One of the option constant to specify the library with the SetFileOption method.

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.

Values for autocommit property

SQLDatabaseMBS.kAutoCommitOff = 0

Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
One of the constants for the autocommit property.
Example
dim db as SQLDatabaseMBS // your database connection

db.AutoCommit = SQLDatabaseMBS.kAutoCommitOn

Autocommit is off.

SQLDatabaseMBS.kAutoCommitOn = 1

Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
One of the constants for the autocommit property.
Example
dim db as SQLDatabaseMBS // your database connection

db.AutoCommit = SQLDatabaseMBS.kAutoCommitOn

Autocommit is on.

SQLDatabaseMBS.kAutoCommitUnknown = -1

Type Topic Plugin Version
const SQL MBS SQL Plugin 12.3
One of the constants for the autocommit property.

Autocommit unknown

The items on this page are in the following plugins: MBS SQL Plugin.


💬 Ask a question or report a problem