<dbPr>
(Database Properties)
This element stores all properties associated with an ODBC or OLE DB external data connection.
Data connectivity can use a number of different technologies. The following is one example XML fragment defining an OLE DB <connection>
and the associated <dbPr>
element:
<connection id="2" odcFile="C:\My Documents\My Data Sources\Northwind Orders.odc" keepAlive="1" name="Northwind Orders" description="northwind" type="5" refreshedVersion="3"> <dbPr connection="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Northwind;Data Source=dataserver1;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LOCAL_MACHINE_NAME;Use Encryption for Data=False;Tag with column collation when possible=False" command=""Northwind"."dbo"."Orders"" commandType="3"/> </connection>
Parent Elements |
---|
|
Attributes |
Description |
---|---|
|
The string containing the database example:
Data connectivity can use a number of different technologies. The following is one example of an ODBC command="SELECT Orders.OrderID, Orders.OrderDate, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry_x000d__x000a_FROM Northwind.dbo.Orders Orders_x000d__x000a_WHERE (Orders.ShipCountry=?)" Some characters in this string have been escaped - for more information on the escaping scheme, please refer to the ST_Xstring type definition. ] Note:
Data connectivity can use a number of different technologies. The following is one example of an OLE DB command=""TESTDB"."ShippersTable"" Note:
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
Specifies the OLE DB command type. Supported values are as follows: 1. Query specifies a cube name 2. Query specifies a SQL statement 3. Query specifies a table name 4. Query specifies that default information has been given, and it is up to the provider how to interpret. 5. Query is against a web based List Data Provider. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
The example:
connection="DRIVER=SQL Server;SERVER=example_server;UID=example_useralias;APP=Microsoft Office 2007;WSID=user_alias;Trusted_Connection=Yes" example:
connection="Provider=OraOLEDB.Oracle.1;Password=example_password;Persist Security Info=True;User ID=example_useralias;Data Source=example_server;Extended Properties=""" Note:
Connection strings syntaxes are specific to individual ODBC or OLE DB data provider drivers. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
Specifies a second command text string that is persisted when PivotTable server-based page fields are in use. For ODBC connections, serverCommand is usually a broader query than The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_DbPr">
<attribute name="connection" use="required" type="ST_Xstring"/>
<attribute name="command" use="optional" type="ST_Xstring"/>
<attribute name="serverCommand" use="optional" type="ST_Xstring"/>
<attribute name="commandType" use="optional" type="xsd:unsignedInt" default="2"/>
</complexType>