OleDbProviderSettings.AllowInProcess OleDbProviderSettings.AllowInProcess OleDbProviderSettings.AllowInProcess Property

Definition

Gets or sets the Boolean property value that specifies whether the OLE DB provider is instantiated as an in-process server.

public:
 property bool AllowInProcess { bool get(); void set(bool value); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone)]
public bool AllowInProcess { get; set; }
Public Property AllowInProcess As Boolean
Property Value

A Boolean value that specifies whether the OLE DB provider is instantiated as an in-process server.

If True, the OLE DB provider is instantiated as an in-process server.

If False (default), the OLE DB provider is instantiated as an external process.

Examples

Using Linked Servers in SMO

Remarks

Instantiating the provider outside the SQL Server process protects the SQL Server process from errors in the provider. When the provider is instantiated outside the SQL Server process, updates or inserts referencing long columns (text, ntext, or image) are not allowed.

Applies to