Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

connectionString Attribute

Office 2007

A string property that contains the ActiveX Data Objects (ADO) connection string to be used to connect to the data source.

Type

xsd:string

Remarks

The connectionString attribute is a required attribute of the adoAdapter element.

Example

The following is an example of the connectionString attribute as it is used in the adoAdapter element:

<xsf:query>
   <xsf:adoAdapter 
      connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
         Password=&quot;&quot;;User ID=Admin;
         Data Source=infnwind.mdb;Mode=Share Deny None;
         Extended Properties=&quot;&quot;;..."
      commandText="select [EmployeeID],[LastName],[FirstName] 
         from [Employees] as [Employees]" 
      queryAllowed="yes"
      submitAllowed="yes">
   </xsf:adoAdapter>
</xsf:query>


Community Additions

ADD
Show:
© 2015 Microsoft