ssml:CT_Connection
Complex type information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-externalConnections.xsd
Content
- Sequence [1..1]
- ssml:dbPr [0..1] ODBC & OLE DB Properties
- ssml:olapPr [0..1] OLAP Properties
- ssml:webPr [0..1] Web Query Properties
- ssml:textPr [0..1] Text Import Settings
- ssml:parameters [0..1] Query Parameters
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| id | [1..1] | xsd:unsignedInt | Connection ID | |
| sourceFile | [0..1] | ssml:ST_Xstring | Source Database File | |
| odcFile | [0..1] | ssml:ST_Xstring | Connection File | |
| keepAlive | [0..1] | xsd:boolean | Keep Connection Open | Default value is "false". |
| interval | [0..1] | xsd:unsignedInt | Automatic Refresh Interval | Default value is "0". |
| name | [0..1] | ssml:ST_Xstring | Connection Name | |
| description | [0..1] | ssml:ST_Xstring | Connection Description | |
| type | [0..1] | xsd:unsignedInt | Database Source Type | |
| reconnectionMethod | [0..1] | xsd:unsignedInt | Reconnection Method | Default value is "1". |
| refreshedVersion | [1..1] | xsd:unsignedByte | Last Refresh Version | |
| minRefreshableVersion | [0..1] | xsd:unsignedByte | Minimum Version Required for Refresh | Default value is "0". |
| savePassword | [0..1] | xsd:boolean | Save Password | Default value is "false". |
| new | [0..1] | xsd:boolean | New Connection | Default value is "false". |
| deleted | [0..1] | xsd:boolean | Deleted Connection | Default value is "false". |
| onlyUseConnectionFile | [0..1] | xsd:boolean | Only Use Connection File | Default value is "false". |
| background | [0..1] | xsd:boolean | Background Refresh | Default value is "false". |
| refreshOnLoad | [0..1] | xsd:boolean | Refresh on Open | Default value is "false". |
| saveData | [0..1] | xsd:boolean | Save Data | Default value is "false". |
| credentials | [0..1] | ssml:ST_CredMethod | Reconnection Method | Default value is "integrated". |
| singleSignOnId | [0..1] | ssml:ST_Xstring | SSO Id |
Used by
- Element ssml:connection