OleDbProviderSettings.AllowInProcess Property

 

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

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool AllowInProcess { get; set; }

Property Value

Type: System.Boolean

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.

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.

Return to top
Show: