Platforms to show: All Mac Windows Linux Cross-Platform

Back to SQLConnectionMBS class.

Previous items Next items

SQLConnectionMBS.kMariaDBClient = 15

Type Topic Plugin Version
const SQL MBS SQL Plugin 22.3
One of the database client constants.

MariaDB client.

SQLConnectionMBS.kMySQLClient = 9

Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
One of the database client constants.

MySQL client.

SQLConnectionMBS.kODBCClient = 1

Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
One of the database client constants.

ODBC client.

SQLConnectionMBS.kOptionAPPNAME = "APPNAME"

Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
A constant for the options.

SQLConnectionMBS.kOptionLibraryCubeSQL = "CUBESQL.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 19.3
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("cubesql.dll")
con.SetFileOption con.kOptionLibraryCubeSQL, f

for CubeSQL.

SQLConnectionMBS.kOptionLibraryDB2 = "DB2CLI.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("db2cli.dll")
con.SetFileOption con.kOptionLibraryDB2, f

for DB2.

SQLConnectionMBS.kOptionLibraryDuckDB = "DUCKDB.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 21.2
ConstantsGroup: Options to specify the library with SetFileOption
Example 
One of the option constant to specify the library with the SetFileOption method.

dim con as SQLConnectionMBS // your connection

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

SQLConnectionMBS.kOptionLibraryFirebird = "IBASE.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("fbclient.dll")
con.SetFileOption con.kOptionLibraryFirebird, f

for Firebird.

SQLConnectionMBS.kOptionLibraryInformix = "INFCLI.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("ICLIT09B.dll")
con.SetFileOption con.kOptionLibraryInformix, f

for Informix.

SQLConnectionMBS.kOptionLibraryInterbase = "IBASE.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("ibclient64.dll")
con.SetFileOption con.kOptionLibraryInterbase, f

for Interbase.

SQLConnectionMBS.kOptionLibraryMySQL = "MYSQL.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("libmysqlclient.18.dylib")
con.SetFileOption con.kOptionLibraryMySQL, f

for MySQL. Library extension on Mac is ".dylib", on Linux ".so" and on Windows ".dll". You get this library with the MySQL download on their homepage.

SQLConnectionMBS.kOptionLibraryODBC = "ODBC.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

con.Option( con.kOptionLibraryODBC) = "/usr/lib/libiodbc.dylib"

for ODBC.

SQLConnectionMBS.kOptionLibraryOracle = "OCI8.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("oci.dll")
con.SetFileOption con.kOptionLibraryOracle, f

for Oracle.

SQLConnectionMBS.kOptionLibraryPostgreSQL = "LIBPQ.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("libpq.dll")
con.SetFileOption con.kOptionLibraryPostgreSQL, f

for Postgre SQL.

SQLConnectionMBS.kOptionLibrarySeparator = ":"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the platform specific path separator.

Use with SetFileOption to specify multiple file paths for a library.
Has a different value on the different platforms.

SQLConnectionMBS.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.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("dbcapi.dll")
con.SetFileOption con.kOptionLibrarySQLanywhere, f

for SQL Anywhere.

SQLConnectionMBS.kOptionLibrarySQLBase = "SQLBASE.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("sqlwntm.dll")
con.SetFileOption con.kOptionLibrarySQLBase, f

for SQLbase.

SQLConnectionMBS.kOptionLibrarySQLite = "SQLITE.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

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

for SQLite. Can also be the spatialite library.

SQLConnectionMBS.kOptionLibrarySybaseComn = "SYBCOMN.LIBS"

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

for Sybase.

SQLConnectionMBS.kOptionLibrarySybaseCS = "SYBCS.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("libsybcs.dll")
con.SetFileOption con.kOptionLibrarySybaseCS, f

for Sybase.

SQLConnectionMBS.kOptionLibrarySybaseCT = "SYBCT.LIBS"

Type Topic Plugin Version
const SQL MBS SQL Plugin 10.5
One of the option constant to specify the library with the SetFileOption method.
Example 
dim con as SQLConnectionMBS // your connection

dim f as FolderItem = GetFolderItem("libsybct.dll")
con.SetFileOption con.kOptionLibrarySybaseCT, f

for Sybase.

SQLConnectionMBS.kOptionLibrarySybaseIntl = "SYBINTL.LIBS"

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

for Sybase.

SQLConnectionMBS.kOptionLibrarySybaseTCL = "SYBTCL.LIBS"

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

for Sybase.

SQLConnectionMBS.kOptionWSID = "WSID"

Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
A constant for the options.

SQLConnectionMBS.kOracleClient = 2

Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
One of the database client constants.

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
One of the database client constants.

PostgreSQL client.

SQLConnectionMBS.kReadCommitted = 1

Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
One of the isolation level constants.
Example 
dim con as SQLConnectionMBS // your connection
con.IsolationLevel = SQLConnectionMBS.kReadCommitted

Read committed.

SQLConnectionMBS.kReadUncommitted = 0

Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
One of the isolation level constants.
Example 
dim con as SQLConnectionMBS // your connection
con.IsolationLevel = SQLConnectionMBS.kReadUncommitted

Read uncommitted.

SQLConnectionMBS.kRepeatableRead = 2

Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
One of the isolation level constants.

Repeatable read.

SQLConnectionMBS.kSerializable = 3

Type Topic Plugin Version
const SQL MBS SQL Plugin 9.3
One of the isolation level constants.

Serializable.

Previous items Next items

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


💬 Ask a question or report a problem
The biggest plugin in space...