Share via

2.6.124 CT_OledbPr

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_Connection

The CT_OledbPr complex type specifies properties of a Model Data Source OLE DB connection ([MS-XLSB] section 2.2.8.9.1).

Child Elements:

dbTables: An element of type CT_DbTables (section 2.6.122) specifying the list of database tables that are used by this connection.

dbCommand: An element of type CT_DbCommand (section 2.6.123) specifying OLE DB command text that is used by this connection.

Attributes:

connection: An attribute of type ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) that specifies the OLE DB connection string.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_OledbPr">
   <xsd:choice minOccurs="1" maxOccurs="1">
     <xsd:element name="dbTables" type="CT_DbTables"/>
     <xsd:element name="dbCommand" type="CT_DbCommand"/>
   </xsd:choice>
   <xsd:attribute name="connection" use="optional" type="x:ST_Xstring"/>
 </xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).