Propriedade do RDL OleDbProviderSettings.DisallowAdHocAccess
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 (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property DisallowAdHocAccess As Boolean
Get
Set
'Uso
Dim instance As OleDbProviderSettings
Dim value As Boolean
value = instance.DisallowAdHocAccess
instance.DisallowAdHocAccess = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool DisallowAdHocAccess { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool DisallowAdHocAccess {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DisallowAdHocAccess : bool with get, set
function get DisallowAdHocAccess () : boolean
function set DisallowAdHocAccess (value : boolean)
Valor da propriedade
Tipo: 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.
Exemplos
Usando servidores vinculados no SMO