A few customers reported issues related to exceptions being thrown during MySQL DB queries on the iDirect Platform connector.

These exceptions seemed to be mostly related to older assemblies being used.

After installing the Microsoft.Data.SqlClient NuGet and updating related XML Serialization Nugets those issues seem gone, though i still have the following exception:

System.AggregateException: One or more errors occurred. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Data.SqlClient.TdsParser' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Data.SqlClient.SNILoadHandle' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x86.dll': The specified module could not be found.

The SqlClient.SNI package is mentioned as an internal consumption package but i tried installing it anyway, which did not solve the issue as well.

Target platform specs (below) seem ok as well as both customers are running Dataminer 10.3.+.

• .NET Framework 4.6.2+ (Windows x86, Windows x64)
• .NET Core 3.1+ (Windows x86, Windows x64, Windows ARM64, Windows ARM, Linux, macOS)
• .NET Standard 2.0+ (Windows x86, Windows x64, Windows ARM64, Windows ARM, Linux, macOS)

Given this, has anyone faced a similar issue or has knowledge on how to fix this issue?

Thanks in advance.