Active Session
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
Maximum amount of active sessions. Unlimited.
|
Data Source Type
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
The provider is a tabular data provider.
|
DBMS Name
Type: VT_BSTR
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
Database server name. The provider identifies InterBase/FireBird/Yaffil
|
DBMS Version
Type: VT_BSTR
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
Database server version
|
Data Source Name
Type: VT_BSTR
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
File path to server database
|
User Name
Type: VT_BSTR
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
Username used to connect to database.
See the initialization property of provider
User ID
|
Provider Version
Type: VT_BSTR
R/W: R
IBProvider v1, v2, v3.
Version of OLEDB provider.
|
Provider Friendly Name
Type: VT_BSTR
R/W: R
| Value: | "LCPI OLE DB Provider for InterBase" |
IBProvider v1, v2, v3.
|
Provider Owned Memory
Type: VT_BOOL
R/W: R
IBProvider v1, v2, v3.
See OLE DB references
|
Read-Only Data Source
Type: VT_BOOL
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
|
ORDER BY Columns in Select List
Type: VT_BOOL
R/W: R
IBProvider v1, v2, v3.
See OLE DB references
|
GROUP BY Support
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_GB_CONTAINS_SELECT |
IBProvider v1, v2, v3.
See OLE DB references
|
Maximum Row Size
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
See OLE DB references
|
Maximum Row Size Includes BLOB
Type: VT_BOOL
R/W: R
IBProvider v1, v2, v3.
See OLE DB references
|
Maximum Index Size
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
See OLE DB references
|
Maximum Tables in SELECT
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
See OLE DB references
|
Identifier Case Sensitivity
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
See OLE DB references
|
Quoted Identifier Sensitivity
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_IC_SENSITIVE |
IBProvider v1, v2, v3.
Available for case of dialect>=3 only See OLE DB references
|
Rowset Conversions on Command
Type: VT_BOOL
R/W: R
IBProvider v1, v2, v3.
See OLE DB references
|
Subquery Support
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_SQ_CORRELATEDSUBQUERIES|
DBPROPVAL_SQ_IN|
DBPROPVAL_SQ_EXISTS|
DBPROPVAL_SQ_COMPARISON |
IBProvider v1, v2, v3.
See OLE DB references
|
Isolation Levels
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_TI_CHAOS|
DBPROPVAL_TI_READCOMMITTED|
DBPROPVAL_TI_REPEATABLEREAD|
DBPROPVAL_TI_SERIALIZABLE |
IBProvider v1, v2, v3.
Supporting transaction isolation levels.
|
Isolation Retention
Type: VT_I4
R/W: R
| Value: | ("IB Base Level"<6)
?DBPROPVAL_TR_COMMIT
:DBPROPVAL_TR_COMMIT|DBPROPVAL_TR_ABORT|DBPROPVAL_TR_BOTH |
IBProvider v1, v2, v3.
See OLE DB references Rollback retaining is available for case of "IB Base Level">=6 and "IB GDS32 Version">=6 only.
|
OLE Object Support
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
A bitmask specifying the ways in which the provider supports access to BLOBs and COM objects stored in columns.
|
Structured Storage
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_SS_ISEQUENTIALSTREAM |
IBProvider v1, v2, v3.
Support of the interface ISequentialStream for objects of storage.
|
Multiple Storage Objects
Type: VT_BOOL
R/W: R
IBProvider v1, v2, v3.
Possibility of simultaneous discovery of several objects-storages (for operation with BLOB)
|
Prepare Abort Behavior
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_CB_PRESERVE |
IBProvider v1, v2, v3.
See OLE DB references
|
Prepare Commit Behavior
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_CB_PRESERVE |
IBProvider v1, v2, v3.
See OLE DB references
|
Provider Name
Type: VT_BSTR
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
Name of file of access component.
|
OLE DB Version
Type: VT_BSTR
R/W: R
IBProvider v1, v2, v3.
OLE BD version, supported by an access component
|
SQL Support
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_SQL_ANSI92_ENTRY|
DBPROPVAL_SQL_ODBC_MINIMUM|
DBPROPVAL_SQL_ODBC_CORE|
DBPROPVAL_SQL_ESCAPECLAUSES |
IBProvider v1, v2, v3.
A bitmask specifying the level of support for SQL.
|
Data Source Object Threading
Type: VT_I4
R/W: R
| Value: | ( free_threading==true)
?DBPROPVAL_RT_FREETHREAD|DBPROPVAL_RT_APTMTTHREAD
:DBPROPVAL_RT_APTMTTHREAD |
IBProvider v1, v2, v3.
Threading model of object of source of data. See OLE DB references
|
Multiple Results
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_MR_SUPPORTED|
DBPROPVAL_MR_CONCURRENT |
IBProvider v1, v2, v3.
Support multiple outcomes.
|
Multiple Parameter Sets
Type: VT_BOOL
R/W: R
IBProvider v1, v2, v3.
Parameter sets. Not supported.
|
Output Parameter Availability
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_OA_ATEXECUTE |
IBProvider v1, v2, v3.
Output parameter data is available immediately after ICommand::Execute returns
|
Open Rowset Support
Type: VT_I4
R/W: R
| Value: | | ibp v1/v2 | — | DBPROPVAL_ORS_TABLE | | ibp v3 | — | DBPROPVAL_ORS_TABLE|DBPROPVAL_ORS_STOREDPROC | |
IBProvider v1, v2, v3.
Features of IOpenRowset interface.
|
Procedure Term
Type: VT_BSTR
R/W: R
IBProvider v1, v2, v3.
Name for an Interbase stored procedure
|
Table Term
Type: VT_BSTR
R/W: R
IBProvider v1, v2, v3.
Name for an InterBase table
|
Catalog Location
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
Indicates the position of the catalog name in a qualified table name in a text command. Not supported.
|
Catalog Term
Type: VT_BSTR
R/W: R
IBProvider v1, v2, v3.
Name for an InterBase database
|
Catalog Usage
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
Bit mask, defining the usage of database name in the query text. Not supported.
|
Schema Term
Type: VT_BSTR
R/W: R
IBProvider v1, v2, v3.
Name for an Interbase database schemata.
|
Schema Usage
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
Bit mask, defining the usage of database schemata name in the query text. Not supported.
|
Transaction DDL
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
Transactions in DLL operations
|
Persistent ID Type
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
The provider uses only symbol names to identify database objects
|
Column Definition
Type: VT_I4
R/W: R
| Value: | DBPROPVAL_CD_NOTNULL |
IBProvider v1, v2, v3.
Possibility to create columns with the limitation NOT NULL
|
Multi-Table Update
Type: VT_BOOL
R/W: R
IBProvider v1, v2, v3.
The Provider doesn't support updating of rowset, formed by query to several tables
|
NULL Collation Order
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
When sorting NULLs are moved to the end of list
|
NULL Concatenation Behavior
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
NULL string is the result of NULL and NOT NULL strings concatenation
|
Heterogeneous Table Support
Type: VT_I4
R/W: R
IBProvider v1, v2, v3.
InterBase doesn't support heterogeneous queries
|
Connection Status
Type: VT_LONG
R/W: R
| Value: | | 0 | — | The not initialized state. | | 1 | — | The source is initialized. | | 2 | — | Loss of connection. | |
IBProvider v1, v2, v3.
The current status of connection.
|
Server Name
Type: Is determined dynamically
R/W: R
| Value: | Name of the database server. |
IBProvider v1, v2, v3.
|
IB Base Level
Type: VT_I4
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
The generation of InterBase (4,5,6)
|
IB Base
Type: VT_BSTR
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
Original string with DBMS version
|
IB Client Level
Type: VT_I4
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2.
The generation of a used DBMS client (4,5,5)
|
new! IB Client
Type: VT_BSTR
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
The string with description of DBMS client
|
new! IB Client Version
Type: VT_BSTR
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
The string with version of DBMS client
|
new! IB Client Name
Type: VT_BSTR
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
The string with name of DBMS client
|
IB Database Dialect
Type: VT_I2
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
The database dialect. Is available for using at client part from IB6.
|
IB ODS Version
Type: VT_I4
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
|
IB ODS Minor Version
Type: VT_I4
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
|
IB Remote Connection
Type: VT_BOOL
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
|
IB Database Page Size
Type: VT_I4
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
|
new! IB Savepoint Support
Type: VT_BOOL
R/W: R
| Value: | Is determined dynamically |
IBProvider v1, v2, v3.
Support of savepoints
| ==0 | — | Server not support savepoints |
| !=0 | — | Server support savepoints |
|
