L.2.12.4 Connection XML
L.2.12.4 Connection XML
Looking at the XML in the workbook connections part that describes the connection whose id=“2”:
<connection id="2" odcFile="
c:\…\externalData.odc" keepAlive="1" name="externalData"
description="FoodMart 2000 - Budget Planing" type="5"
refreshedVersion="3" background="1">
<dbPr connection="Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=True;Data Source=xlextdat8;Initial
Catalog=AdamTest;Client
Cache Size=25;Auto Synch Period=10000;MDX Compatibility=1"
command="Budget" commandType="1"/>
<olapPr sendLocale="1" rowDrillCount="1000"/>
</connection>Attributes on the connection element express properties about the connection.
Attributes on the dbPr element express additional properties on the connection.
Attributes on the olapPr element express properties that apply to connections to OLAP data sources.
Last updated on