-
Users Handbook
-
-
-
- Intro & Basics
- All Objects have Descriptions
- Check for unused procedures
- Compiled Procedures up to date
- Invalid Source Layers
- Required Columns
- Check for abnormally ended Jobs
- Check for blocked Jobs
- Check for disabled Tasks
- Check for duplicate tasks in different Jobs
- Check for duplicate tasks in same Job
-
-
-
Administrators Handbook
-
- Register URL
- Configure SSL/HTTPS
- Configure Proxy-Server
- How to edit the appsettings.json file
- System Settings
- Global Parameters
- Allow Service Account to Logon as a Service
- LDAP & SSO Authentication
- Migrating Testcases and Configuration
- Licenses Management
- Manual Configuration
- Exposing the BiG EVAL REST API to other Network Segments
-
- Articles coming soon
-
Developers Handbook
-
Known Problems
-
Demo Virtual Machine
-
Release Notes
-
General
List installed OLE DB providers
Last Updated On
- Home
- Developers Handbook
- PowerShell
- List installed OLE DB providers
The following PowerShell script comes from:
http://dbadailystuff.com/list-all-ole-db-providers-in-powershell
<# .SYNOPSIS Returns a list of all OLE DB Providers that are registered in the system .DESCRIPTION Returns a List of all OLE DB Providers that are registered in the system Every element in the list has the following properties: SOURCES_NAME SOURCES_PARSENAME SOURCES_DESCRIPTION SOURCES_TYPE SOURCES_ISPARENT SOURCES_CLSID NOTE: OLE DB providers are 32-bits and 64-bits aware/specific. .EXAMPLE C:\PS> Get-OledbRegistered .EXAMPLE $list = Get-OledbRegistered $list | ?{ $_.SOURCES_DESCRIPTION.IndexOf('SQL Server') -ge 0 } To list all "SQL Server" providers #> function Get-OledbRegistered { [CmdletBinding()] [OutputType([System.Collections.Generic.List[PSObject]])] param () Process { $list = New-Object ([System.Collections.Generic.List[PSObject]]) foreach ($provider in [System.Data.OleDb.OleDbEnumerator]::GetRootEnumerator()) { $v = New-Object PSObject for ($i = 0; $i -lt $provider.FieldCount; $i++) { Add-Member -in $v NoteProperty $provider.GetName($i) $provider.GetValue($i) } $list.Add($v) } return $list } } Get-OledbRegistered
Table of Contents