SQLConnectionMBS.kANSILevel0 = 0
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the ANSI level constants.
Notes: ANSI Level 0

SQLConnectionMBS.kANSILevel1 = 1
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the ANSI level constants.
Notes: ANSI Level 1

SQLConnectionMBS.kANSILevel2 = 2
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the ANSI level constants.
Notes: ANSI Level 2

SQLConnectionMBS.kANSILevel3 = 3
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the ANSI level constants.
Notes: ANSI Level 3

SQLConnectionMBS.kAutoCommitOff = 0
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the constants for the autocommit property.
Notes: Autocommit is off.

SQLConnectionMBS.kAutoCommitOn = 1
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the constants for the autocommit property.
Notes: Autocommit is on.

SQLConnectionMBS.kAutoCommitUnknown = -1
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the constants for the autocommit property.
Notes: Autocommit unknown

SQLConnectionMBS.kClientNotSpecified = 0
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: Client is not specified.

SQLConnectionMBS.kDB2Client = 6
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: DB2 client.

SQLConnectionMBS.kFirebirdClient = 4
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.4, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: InterBase/Firebird client.

SQLConnectionMBS.kInformixClient = 7
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: Informix client.

SQLConnectionMBS.kInterBaseClient = 4
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: InterBase/Firebird client.

SQLConnectionMBS.kLevelUnknown = -1
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the isolation level constants.
Notes: Unknown

SQLConnectionMBS.kMySQLClient = 9
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: MySQL client.

SQLConnectionMBS.kODBCClient = 1
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: ODBC client.

SQLConnectionMBS.kOptionAPPNAME = "APPNAME"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: A constant for the options.

SQLConnectionMBS.kOptionLibraryDB2 = "DB2CLI.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for DB2.

SQLConnectionMBS.kOptionLibraryFirebird = "IBASE.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Firebird.

SQLConnectionMBS.kOptionLibraryInformix = "INFCLI.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Informix.

SQLConnectionMBS.kOptionLibraryInterbase = "IBASE.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Interbase.

SQLConnectionMBS.kOptionLibraryMySQL = "MYSQL.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: 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"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for ODBC.

SQLConnectionMBS.kOptionLibraryOracle = "OCI8.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Oracle.

SQLConnectionMBS.kOptionLibraryPostgreSQL = "LIBPQ.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Postgre SQL.

SQLConnectionMBS.kOptionLibrarySeparator = ":"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the platform specific path separator.
Notes:
Use with SetFileOption to specify multiple file paths for a library.
Has a different value on the different platforms.

SQLConnectionMBS.kOptionLibrarySQLBase = "SQLBASE.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for SQLbase.

SQLConnectionMBS.kOptionLibrarySQLite = "SQLITE.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for SQLite. Can also be the spatialite library.

SQLConnectionMBS.kOptionLibrarySybaseComn = "SYBCOMN.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: OOne of the option constant to specify the library with the SetFileOption method.
Notes: for Sybase.

SQLConnectionMBS.kOptionLibrarySybaseCS = "SYBCS.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Sybase.

SQLConnectionMBS.kOptionLibrarySybaseCT = "SYBCT.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Sybase.

SQLConnectionMBS.kOptionLibrarySybaseIntl = "SYBINTL.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Sybase.

SQLConnectionMBS.kOptionLibrarySybaseTCL = "SYBTCL.LIBS"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 10.5, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the option constant to specify the library with the SetFileOption method.
Notes: for Sybase.

SQLConnectionMBS.kOptionWSID = "WSID"
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: A constant for the options.

SQLConnectionMBS.kOracleClient = 2
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes:
Oracle client.

For Windows the file is "oci.dll", for Linux libclntsh.so and for Mac OS X libclntsh.dylib.

SQLConnectionMBS.kPostgreSQLClient = 10
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: PostgreSQL client.

SQLConnectionMBS.kReadCommitted = 1
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the isolation level constants.
Notes: Read committed.

SQLConnectionMBS.kReadUncommitted = 0
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the isolation level constants.
Notes: Read uncommitted.

SQLConnectionMBS.kRepeatableRead = 2
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the isolation level constants.
Notes: Repeatable read.

SQLConnectionMBS.kSerializable = 3
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the isolation level constants.
Notes: Serializable.

SQLConnectionMBS.kSQLBaseClient = 5
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: SQLbase client.

SQLConnectionMBS.kSQLiteClient = 11
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: SQLite client. Or spatialite.

SQLConnectionMBS.kSQLServerClient = 3
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes:
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
const, SQL, MBS Real Studio SQL Plugin (SQL), class SQLConnectionMBS,
Plugin version: 9.3, Mac: Yes, Win: Yes, Linux: Yes, Console & Web: No, Feedback.

Function: One of the database client constants.
Notes: Sybase client.