Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the connection string used for an ADOAdapterObject object.
Namespace: Microsoft.Office.Interop.InfoPath
Assembly: Microsoft.Office.Interop.InfoPath (in Microsoft.Office.Interop.InfoPath.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
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.
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();