Share via


ADOAdapter2.Connection property

Gets or sets the connection string used for an ADOAdapterObject object.

Namespace:  Microsoft.Office.Interop.InfoPath.SemiTrust
Assembly:  Microsoft.Office.Interop.InfoPath.SemiTrust (in Microsoft.Office.Interop.InfoPath.SemiTrust.dll)

Syntax

'Declaration
Property Connection As String
    Get
    Set
'Usage
Dim instance As ADOAdapter2
Dim value As String

value = instance.Connection

instance.Connection = value
string Connection { get; set; }

Property value

Type: System.String

Implements

ADOAdapter.Connection

Remarks

The Connection property of the ADOAdapter object contains the connection string that is used by the ADO data adapter to connect to an ActiveX Data Objects/OLEDB external data source.

Note

The ADOAdapter object is limited to work only with Microsoft SQL Server and Microsoft Access databases.

Important

This member can be accessed only by forms running in the same domain as the currently open form, or by forms that have been granted cross-domain permissions.

Examples

// retrieve the Employees Adapter from the DataAdapters collection
ADOAdapter employeesDA = (ADOAdapter)thisXDocument.DataAdapters["Employees"];
// Get new server name from the main DOM
string newServer = thisXDocument.DOM.selectSingleNode("//my:serverName").text;
// build new connection string
string connectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;";
connectionString += "Initial Catalog=SalesDB;Data Source=" + newServer;
// set new connection string
employeesDA.Connection = connectionString;
// query the data source again
DataObject employeesDO = thisXDocument.DataObjects["Employees"];
employeesDO.Query();

See also

Reference

ADOAdapter2 interface

ADOAdapter2 members

Connection overload

Microsoft.Office.Interop.InfoPath.SemiTrust namespace