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