The ExplorerOM SDK samples fail on SQL binary collation

  • Article

Problem

The ExplorerOM SDK samples have a database name in the connection string with the incorrect case which causes it to fail on binary collation SQL.

How do I fix it?

  1. Open the Delete Party ExplorerOM SDK sample found at <ProdDir>\SDK\Samples\Admin\ExplorerOM\DeleteParty.

  2. Locate the DeleteParty.cs file.

  3. Change Line 58 of the DeleteParty.cs file to:

    catalog.ConnectionString = string.Format("SERVER={0};DATABASE={1};Integrated Security=SSPI", SystemInformation.ComputerName, "BizTalkMgmtDb");

  4. Open the Unenlist Parties ExplorerOM SDK sample found at <ProdDir>\SDK\Samples\Admin\ExplorerOM\UnenlistParties.

  5. Locate the UnenlistParties.cs file.

  6. Change line 58 of the UnenlistParties.cs file needs to change to:

    catalog.ConnectionString = string.Format("SERVER={0};DATABASE={1};Integrated Security=SSPI", SystemInformation.ComputerName, "BizTalkMgmtDb");

See all of our documentation issues we are blogging about:
https://blogs.msdn.com/luke/category/7759.aspx