Problem connecting to MariaDB

Support
1

Hello Community,
when connecting to a SQL MariaDB, I have a problem. After entering all parameters like User, Password, Server, Port and Database name, i click “Test”. I get the message “Test connection succeeded.”, but when i try to query from the database the following two error messages appear alternating:
- Object cannot be cast from DBNull to other types
- The given key was not present in the dictionary

Here is the Debug log:

grafik
grafik1355×859 159 KB

My current version of EasyMorph is 5.4.3.10. The version of the MariaDB is 10.

Can someone help me with this problem?

Kind regards

2

Hello @User1,

It seems that MariaDB starting from version 10.10, is no longer compatible with MySQL Connector/NET, used internally by EasyMorph’s native MySQL connector: https://bugs.mysql.com/bug.php?id=109331

We will discuss how to approach this. For now, the possible workaround is to use an ODBC connector and MariaDB ODBC driver.