Share via

2.2.1 CT_Connection

  • Article

Specifies the properties of the connection (2). The following table specifies the child elements of this type.

Child element

Meaning

ConnectionString

Specifies a connection string to establish a data connection (1) to the data source.

If Type is "ODBC", the string is specified by [MS-ODBCSTR].

If Type is "OLEDB", the string is specified by [MS-OLEDBSTR]. If Type is "DATAFEED", the string is specified by [MS-ODATA].

CommandType

Specifies the command type.

This element MUST be present when Type is "OLEDB" and CommandText is present as a non-empty element. This element MUST be present when Type is "DATAFEED" with the value of "TableCollection". This element MUST NOT be present when Type is "ODBC".

Parameter

Specifies information about a parameter in a SQL query.

This element MUST NOT be present when Type is "OLEDB" or "DATAFEED".

CommandText

If Type is "ODBC", this specifies a SQL query.

If Type is "OLEDB" or "DATAFEED", this specifies that text be interpreted according to the CommandType.

SSOApplicationID

The application identifier used for SSO authentication. SHOULD be specified only when CredentialsMethod is "Stored".

CredentialsMethod

Specifies the method to use for authentication.

If the value is "Stored", the value of SSOApplicationID will be used for the SSO application identifier.

If this element is not present, the value is "Integrated".

AlwaysUseConnectionFile

Specifies whether to always use the ODC file when the data is displayed or refreshed.

If true, this specifies when establishing another data connection (1) that the ODC file is to be read again.

If this element is not present, the value is false.

Culture

Specifies the language associated with the data connection (2). MUST<3> be a language tag as specified by [RFC3066].<4>

If this element is not present, the data connection (2) is using the server language.

The following table specifies the attributes of this type.

Attributes

Meaning

Type

Specifies the connection (2) type.

The following table lists all other types which reference this type.

Referenced by

OfficeDataConnection

The following XML schema fragment defines this element.

 <?xml version="1.0" encoding="utf-8" ?>
 <xs:schema
   targetNamespace="urn:schemas-microsoft-com:office:odc"
   elementFormDefault="qualified"
   xmlns="urn:schemas-microsoft-com:office:odc"
   xmlns:xs="http://www.w3.org/2001/XMLSchema">
  
   <xs:complexType name="CT_Connection">
     <xs:sequence>
       <xs:element name="ConnectionString" type="xs:string" />
       <xs:element name="CommandType" minOccurs="0" type="ST_CommandType" />
       <xs:element name="Parameter" minOccurs="0" maxOccurs="unbounded"
         type="CT_Parameter" />
       <xs:element name="CommandText" minOccurs="0" type="xs:string" />
       <xs:element name="SSOApplicationID" minOccurs="0" type="xs:string" />
       <xs:element name="CredentialsMethod" minOccurs="0"
         type="ST_CredentialsMethod" default="Integrated" />
       <xs:element name="AlwaysUseConnectionFile" minOccurs="0"
         type="xs:boolean" default="true" />
       <xs:element name="Culture" minOccurs="0" type="xs:string" />
     </xs:sequence>
     <xs:attribute name="Type" type="ST_ConnectionType" form="qualified"
       use="required" />
   </xs:complexType>
  
 </xs:schema>