Get "Could not load file or assembly 'MySql.Data..." error connecting to Local Storage
说明
The following error messages are received when trying to connect to Local Storage.
Error #1: Quest.Toad.Exceptions.BaseException Encountered exception while processing exception
System.IO.FileNotFoundException Could not load file or assembly 'MySql.Data, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependences. The system cannot find the file specified. Stack Trace: at Quest.Toad.MySQL.MySQLExceptionWrapper.HandleException(Object sender, ExceptionEventArgs args) at Quest.Toad.Notification.NotificationManager.ExceptionDelegate(Object sender, ExceptionEventArgs args)
System.IO.FileNotFoundException Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependences. The system cannot find the file specified.
Error #2: System.IO.FileNotFoundException Could not load file or assembly 'MySql.Data, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependences. The system cannot find the file specified. Stack Trace: at Quest.Toad.CloudDB.CloudDBConnection.DoBeforeConnect() at Quest.Toad.DB.Connection.Connect(Boolean notify) at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
System.IO.FileNotFoundException Could not load file or assembly 'MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependences. The system cannot find the file specified.
原因
MySql.Data Connector 6.9.5 has several bugs in it.
解决办法
Download and install the latest MySql.data .NET connector. Then re-install Toad Data Point.
其他信息
A side effect of the bad MySql.Data Connector, is when un-installing and re-installing Toad Data Point, the “C:\Users\\AppData\Local\Quest Software\Toad Data Point Hub Data” directory does not get installed. This folder is associated with Local Storage.
