Description:
When trying to alter a trigger (before-insert) VS2017 fails with the message:
'unable to load object with error:
[a]mysql.data.mysqlclient.mysqlconnection cannot cast to [b]mysql.data.mysqlclient.mysqlconnection
Typpe A originates from 'mysql.data version=6.10.7.0,,, in the context 'default' at location F:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\PrivateAssemblies\mysql.data.dll
Typpe B originates from 'mysql.data version=7.0.12.0,...,,, in the context 'default' at location C:\Windows\Microsoft.NET\assembly\GAC_MSIL\MySql.Data\v4.0_8.0.12.0__c5687fc88969c44d\mysql.data.dll'.
There are obviously two different versions trying to exchange data that are not compatible. I uninstalled mysql-for=vs and reinstalled it. I uninstalled the .net mysql driver and reinstalled it. Both are 32bit versions on a 64bit mysql svr and a 64bit vs107 installation.(?)
Trying to alter a stored procedure shows no error message but does not open an edit window.
The objects (all of them including SPs and triggers) appear in the object tree (left).
I did not find entries in the locations in event viewer that seemed to be prone to hold such info.
How to repeat:
?
