"SetPropertyValue $Dsn.PropertyValue" doesn't work if ClientCertificate is set to null.

[CoyoteProd]

in the code here :

$DsnArray = Get-OdbcDsn -DriverName 'SQL Server Native Client 10.0'
ForEach ($Dsn in $ DsnArr) {
          Remove-OdbcDsn -InputObject $Dsn 
          # You can change the property array as well, 
          # if DSN attributes have been changed in the new driver version

Add-OdbcDsn -Name $Dsn.Name -DsnType $Dsn.DsnType -Platform $Dsn.Platform -DriverName 'SQL Server Native Client 12.0' -SetPropertyValue $Dsn.PropertyValue
}

The properties SetPropertyValue $Dsn.PropertyValue doesn't work if ClientCertificate is set to null.
In this case an error is poped:

dd-OdbcDsn : Erreur de syntaxe dans le paramètre SetPropertyValue {ClientCertificate=}. Le paramètre doit être au
format "MyKey=MyValue".
Au caractère Ligne:1 : 1
+ Add-OdbcDsn -name $dsn.Name -DriverName $dsn.DriverName -SetPropertyV ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (MSFT_OdbcDsnTask:Root/Microsoft/...SFT_OdbcDsnTask) [Add-OdbcDsn], CimExc
   eption
    + FullyQualifiedErrorId : MI RESULT 1,Add-OdbcDsn

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: 5e1a60eb-a37d-8b59-5b67-fa4bde46cb17
• Version Independent ID: c67b845b-c7d3-d084-52ba-154f7ddb4ab2
• Content: Add-OdbcDsn (Wdac)
• Content Source: docset/winserver2022-ps/wdac/Add-OdbcDsn.md
• Product: w10
• Technology: windows
• GitHub Login: @JasonGerend
• Microsoft Alias: jgerend

[officedocspr5]

To make it easier for you to submit feedback on articles on learn.microsoft.com, we're transitioning our feedback system from GitHub Issues to a new experience.

As part of the transition, this GitHub Issue will be moved to a private repository. We're moving Issues to another repository so we can continue working on Issues that were open at the time of the transition. When this Issue is moved, you'll no longer be able to access it.

If you want to provide additional information before this Issue is moved, please update this Issue before December 15th, 2023.

With the new experience, you no longer need to sign in to GitHub to enter and submit your feedback. Instead, you can choose directly on each article's page whether the article was helpful. Then you can then choose one or more reasons for your feedback and optionally provide additional context before you select Submit.

Here's what the new experience looks like.

Note: The new experience is being rolled out across learn.microsoft.com in phases. If you don't see the new experience on an article, please check back later.

First, select whether the article was helpful:

Then, choose at least one reason for your feedback and optionally provide additional details about your feedback:

Article was helpful	Article was unhelpful

Finally, select Submit and you're done!