Export (0) Print
Expand All

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: 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft