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


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

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