Error 'Object cannot be cast from DBNull to other types.' when trying to connect to MariaDB v10.11
说明
When trying to connect to MariaDB 10.11 in Toad Data Point, the following error appears:
System.InvalidCastException Object cannot be cast from DBNull to other types. Stack Trace: at System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) at MySql.Data.MySqlClient.Driver.LoadCharacterSets(MySqlConnection connection) at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection) at MySql.Data.MySqlClient.MySqlConnection.Open() at Quest.Toad.MySQL.MySQLConnection.OpenInitialTestConnection() at Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect() at Quest.Toad.Db.Connection.Connect(Boolean notify) at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()