• Article

OleDbProviderSettings.DisallowAdHocAccess Property

Gets or sets the Boolean property value that specifies whether SQL Server allows ad hoc access to data by using OPENROWSET and OPENDATASOURCE functions with the OLE DB provider.

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

Syntax

'Declaration
<SfcPropertyAttribute> _
Public Property DisallowAdHocAccess As Boolean
    Get
    Set
'Usage
Dim instance As OleDbProviderSettings
Dim value As Boolean

value = instance.DisallowAdHocAccess

instance.DisallowAdHocAccess = value

[SfcPropertyAttribute]
public bool DisallowAdHocAccess { get; set; }

[SfcPropertyAttribute]
public:
property bool DisallowAdHocAccess {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute>]
member DisallowAdHocAccess : bool with get, set

function get DisallowAdHocAccess () : boolean
function set DisallowAdHocAccess (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether SQL Server allows ad hoc functions with the OLE DB provider.
If True, ad hoc functions are not allowed.
If False (default), ad hoc function are allowed.