x-OdbcDsn workarounds (PowerShell/PowerShell#12427)

snippets.ps1

# Get
Invoke-CimMethod -ClassName MSFT_OdbcDsnTask `
                 -Namespace ROOT\Microsoft\Windows\Wdac `
                 -MethodName 'Get' `
                 -Arguments @{
                     Name       = $Name
                     DsnType    = [string]$DsnType
                     Platform   = $Platform
                     DriverName = $DriverName
                 }

# Add DSN
    Invoke-CimMethod -ClassName MSFT_OdbcDsnTask `
                     -Namespace ROOT\Microsoft\Windows\Wdac `
                     -MethodName 'Add' `
                     -Arguments @{
                         Name       = $Name
                         DsnType    = [string]$DsnType
                         Platform   = $Platform
                         DriverName = $DriverName
                     }
                     
# Remove DSN
    Invoke-CimMethod -ClassName MSFT_OdbcDsnTask `
                     -Namespace ROOT\Microsoft\Windows\Wdac `
                     -MethodName 'RemoveByName' `
                     -Arguments @{
                         Name       = $Name
                         DsnType    = [string]$DsnType
                         Platform   = $Platform
                         DriverName = $DriverName
                     }

# Set DSN Property
    Invoke-CimMethod -ClassName MSFT_OdbcDsnTask `
                     -Namespace ROOT\Microsoft\Windows\Wdac `
                     -MethodName 'SetByName' `
                     -Arguments @{
                         Name             = $Name
                         DsnType          = [string]$DsnType
                         Platform         = $Platform
                         DriverName       = $DriverName
                         SetPropertyValue = ,"$Key=$Value"
                     }

# Remove DSN Property
    Invoke-CimMethod -ClassName MSFT_OdbcDsnTask `
                     -Namespace ROOT\Microsoft\Windows\Wdac `
                     -MethodName 'SetByName' `
                     -Arguments @{
                         Name                = $Name
                         DsnType             = [string]$DsnType
                         Platform            = $Platform
                         DriverName          = $DriverName
                         RemovePropertyValue = ,$Key
                     }