7.5.6. Data Source Objects
Initialization and Authorization Properties
VIRTOLEDB supports the following properties in the initialization property group.
Table 7.21. Supported Initialization and Authorization Properties
| Property | R/W | Default | Notes |
|---|---|---|---|
| DBPROP_AUTH_PASSWORD | Read/Write | General Info: Password | |
| DBPROP_AUTH_USERID | Read/Write | User ID | |
| DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO | Read/Write | VARIANT_FALSE | Persist Security Info |
| DBPROP_INIT_DATASOURCE | Read/Write | Data Source | |
| DBPROP_INIT_CATALOG | Read/Write | Initial Catalog | |
| DBPROP_INIT_PROVIDERSTRING | Read/Write | Extended Properties | |
| DBPROP_INIT_HWND | Read/Write | Window Handle | |
| DBPROP_INIT_PROMPT | Read/Write | DBPROMPT_COMPLETE | Prompt |
| DBPROP_INIT_TIMEOUT | Read/Write | 0 | Connect Timeout |
In addition, VIRTOLEDB implements a provider-specific property set DBPROPSET_VIRTUOSODBINIT with the following properties
Table 7.22. Provider-Specific Initialization and Authorization Properties
| Property | R/W | Default | Notes |
|---|---|---|---|
| VIRTPROP_INIT_ENCRYPT | Read/Write | VARIANT_FALSE |
Type: VT_BOOL Description: Encrypt Connection If this property is set to VARIANT_TRUE the provider uses SSL encrypted connections. |
| VIRTPROP_AUTH_PKCS12FILE | Read/Write |
Type: VT_BSTR Description: PKCS #12 File If this property is set to a non-empty string then it is used as a name of a PKCS #12 file that authenticates the client. This also implies that the VIRTPROP_INIT_ENCRYPT property is set to VARIANT_TRUE |
Data Source Properties
VIRTOLEDB supports the following properties in the data source property group.
Table 7.23. Supported Data Source Properties
| Property | R/W | Default | Notes |
|---|---|---|---|
| DBPROP_CURRENTCATALOG | Read/Write | Current Catalog | |
| DBPROP_MULTIPLECONNECTIONS | Read/Write | Multiple Connections |
Data Source Information Properties
VIRTOLEDB supports the following properties in the data source information property group.
Table 7.24. Supported Data Source Information Properties
| Property | R/W | Default | Notes |
|---|---|---|---|
| DBPROP_ACTIVESESSIONS | Read-Only | The number of connections the Virtuoso server is licensed to. | |
| DBPROP_ASYNCTXNABORT | Read-Only | VARIANT_FALSE | VIRTOLEDB cannot abort transactions asynchronously. |
| DBPROP_ASYNCTXNCOMMIT | Read-Only | VARIANT_FALSE | VIRTOLEDB cannot commit transactions asynchronously. |
| DBPROP_BYREFACCESSORS | Read-Only | VARIANT_FALSE | VIRTOLEDB does not support reference accessors. |
| DBPROP_CATALOGLOCATION | Read-Only | DBPROPVAL_CL_START | |
| DBPROP_CATALOGTERM | Read-Only | "qualifier" | |
| DBPROP_CATALOGUSAGE | Read-Only | DBPROPVAL_CU_DML_STATEMENTS | DBPROPVAL_CU_TABLE_DEFINITION | DBPROPVAL_CU_INDEX_DEFINITION | DBPROPVAL_CU_PRIVILEGE_DEFINITION | |
| DBPROP_COLUMNDEFINITION | Read-Only | DBPROPVAL_CD_NOTNULL | |
| DBPROP_COMSERVICES | Read-Only | 0 | |
| DBPROP_CONCATNULLBEHAVIOR | Read-Only | DBPROPVAL_CB_NULL | |
| DBPROP_CONNECTIONSTATUS | Read-Only | DBPROPVAL_CS_INITIALIZED | |
| DBPROP_DATASOURCENAME | Read-Only | N/A | |
| DBPROP_DATASOURCEREADONLY | Read-Only | VARIANT_FALSE | |
| DBPROP_DATASOURCE_TYPE | Read-Only | DBPROPVAL_DST_TDP | |
| DBPROP_DBMSNAME | Read-Only | "Virtuoso" | |
| DBPROP_DBMSVER | Read-Only | ||
| DBPROP_DSOTHREADMODEL | Read-Only | DBPROPVAL_RT_FREETHREAD | |
| DBPROP_GROUPBY | Read-Only | DBPROPVAL_GB_NO_RELATION | |
| DBPROP_HETEROGENEOUSTABLES | Read-Only | DBPROPVAL_HT_DIFFERENT_CATALOGS | |
| DBPROP_IDENTIFIERCASE | Read-Only | DBPROPVAL_IC_SENSITIVE | |
| DBPROP_MAXINDEXSIZE | Read-Only | 2000 | |
| DBPROP_MAXOPENCHAPTERS | Read-Only | 0 | |
| DBPROP_MAXROWSIZE | Read-Only | 2000 | |
| DBPROP_MAXROWSIZEINCLUDESBLOB | Read-Only | VARIANT_FALSE | |
| DBPROP_MAXTABLESINSELECT | Read-Only | 0 | |
| DBPROP_MULTIPLEPARAMSETS | Read-Only | VARIANT_TRUE | |
| DBPROP_MULTIPLERESULTS | Read-Only | DBPROPVAL_MR_SUPPORTED | |
| DBPROP_MULTIPLESTORAGEOBJECTS | Read-Only | VARIANT_FALSE | |
| DBPROP_MULTITABLEUPDATE | Read-Only | VARIANT_TRUE | |
| DBPROP_NULLCOLLATION | Read-Only | DBPROPVAL_NC_HIGH | |
| DBPROP_OLEOBJECTS | Read-Only | DBPROPVAL_OO_BLOB | |
| DBPROP_OPENROWSETSUPPORT | Read-Only | DBPROPVAL_ORS_TABLE | |
| DBPROP_ORDERBYCOLUMNSINSELECT | Read-Only | VARIANT_FALSE | |
| DBPROP_OUTPUTPARAMETERAVAILABILITY | Read-Only | DBPROPVAL_OA_ATROWRELEASE | |
| DBPROP_PERSISTENTIDTYPE | Read-Only | DBPROPVAL_PT_NAME | |
| DBPROP_PREPAREABORTBEHAVIOR | Read-Only | DBPROPVAL_CB_PRESERVE | |
| DBPROP_PREPARECOMMITBEHAVIOR | Read-Only | DBPROPVAL_CB_PRESERVE | |
| DBPROP_PROCEDURETERM | Read-Only | "procedure" | |
| DBPROP_PROVIDERFRIENDLYNAME | Read-Only | "OpenLink OLE DB Provider for Virtuoso" | |
| DBPROP_PROVIDERMEMORY | Read-Only | VARIANT_TRUE | |
| DBPROP_PROVIDERFILENAME | Read-Only | "virtoledb.dll" | |
| DBPROP_PROVIDEROLEDBVER | Read-Only | "02.60" | |
| DBPROP_PROVIDERVER | Read-Only | ||
| DBPROP_QUOTEDIDENTIFIERCASE | Read-Only | DBPROPVAL_IC_SENSITIVE | |
| DBPROP_ROWSETCONVERSIONSONCOMMAND | Read-Only | VARIANT_TRUE | |
| DBPROP_SCHEMATERM | Read-Only | "owner" | |
| DBPROP_SCHEMAUSAGE | Read-Only | DBPROPVAL_SU_DML_STATEMENTS | DBPROPVAL_SU_TABLE_DEFINITION | DBPROPVAL_SU_INDEX_DEFINITION | DBPROPVAL_SU_PRIVILEGE_DEFINITION | |
| DBPROP_SERVERNAME | Read-Only | ||
| DBPROP_SQLSUPPORT | Read-Only | DBPROPVAL_SQL_ODBC_MINIMUM | DBPROPVAL_SQL_ODBC_CORE | DBPROPVAL_SQL_ANSI89_IEF | DBPROPVAL_SQL_ESCAPECLAUSES | DBPROPVAL_SQL_ANSI92_ENTRY | |
| DBPROP_STRUCTUREDSTORAGE | Read-Only | DBPROPVAL_SS_ISEQUENTIALSTREAM | |
| DBPROP_SUBQUERIES | Read-Only | DBPROPVAL_SQ_CORRELATEDSUBQUERIES | DBPROPVAL_SQ_COMPARISON | DBPROPVAL_SQ_EXISTS | DBPROPVAL_SQ_IN | DBPROPVAL_SQ_QUANTIFIED | DBPROPVAL_SQ_TABLE | |
| DBPROP_SUPPORTEDTXNDDL | Read-Only | DBPROPVAL_TC_DML | |
| DBPROP_SUPPORTEDTXNISOLEVELS | Read-Only | DBPROPVAL_TI_READUNCOMMITTED | DBPROPVAL_TI_READCOMMITTED | DBPROPVAL_TI_REPEATABLEREAD | DBPROPVAL_TI_SERIALIZABLE | |
| DBPROP_SUPPORTEDTXNISORETAIN | Read-Only | DBPROPVAL_TR_DONTCARE | |
| DBPROP_TABLESTATISTICS | Read-Only | 0 | |
| DBPROP_TABLETERM | Read-Only | "table" | |
| DBPROP_USERNAME | Read-Only | N/A |