2.4.5.2.1 CT_DataConnection

  • Article

Referenced by: CT_DataConnections

The CT_DataConnection complex type specifies a data connection.

Attributes:

ID : An xsd:unsignedLong ([XMLSCHEMA2] section 3.3.21) attribute that specifies the identifier of a CT_DataConnection. It MUST be unique amongst all the DataConnection child elements of the containing CT_DataConnections.

ConnectionString :  An optional xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the connection string to a data source. It MUST be a valid connection string as specified in [MS-ODBCSTR]. The type of the data source specified in the connection string MUST be from the following table.

Type of data source

Syntax

OLE DB

MUST be a valid connection string as specified in [MS-ODBCSTR]

ODBC

MUST be a valid connection string as specified in [MS-ODBCSTR]

List

MUST be in the following format:

"PROVIDER=WSS;DATABASE=list URL;LIST={list GUID};viewparam"

  • list URL is the URL of a list

  • list GUID is the GUID of the list

  • viewparam MUST be in the format "VIEW={view GUID};" if the data source is a view of a list, where view GUID is the GUID of the view; otherwise, viewparam MUST be an empty string

Workbook

MUST be in the following format:

"DataModule=Microsoft.Office.Visio.Server.EcsDataHandler,Microsoft.Office.Visio.Server; Data Source=workbook URL;Extended Properties='HDR=hdrvalue;';"

  • hdrvalue equals YES if the first row of data is the header row, and NO otherwise

  • workbook URL is the URL of a workbook

Custom

MUST be in the following format:

"DataModule=class name,assembly name;Add-in key=value pairs;"

  • class name is a class name

  • assembly name is an assembly name

  • value pairs is a semicolon-separated set of key-value pairs specific to the add-in

Filename :  An optional xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the full path of an ODC file. If the ConnectionString attribute exists, this attribute MUST NOT exist. If the ConnectionString attribute does not exist, this attribute MUST exist.

 <xsd:complexType name="CT_DataConnection">
   <xsd:attribute name="ID" type="xsd:unsignedLong" use="required"/>
   <xsd:attribute name="ConnectionString" type="xsd:string" use="optional"/>
   <xsd:attribute name="Filename" type="xsd:string" use="optional"/>
 </xsd:complexType>