Help! Unable to Successfully create a Datasource to MySQL DB
-
Hi All, - Using - Visual Studio 2017(15.8.7) MySQL for VS 2.05 MySQL Connector .net 6.9.9 I apparently made a grave mistake of running some recommended updates on the Nuget Manager and now I am unable to successfully set up any datasource to my MySQL DB(v8.0.12). I've even tried using(MySQL for VS 1.2.7 with Connector 6.9.8) as well with no luck and Installing MySQL.Data from Nuget with various versions and still no go! There is obviously something I'm missing or something extra is there that may be conflicting but I am not sure what it is. My question simply is: Can anyone give me a step by step on what configuration i need along with Visual Studio, MySQL for VS, MySQL Connector .net(if necessary), MySQL.Data etc so I can successfully set up and use a SQL DATASOURCE with a MySQL(v8.0.12) Database(or is it possible)? Any help is greatly appreciated Patrick Hi, I was able to solve my issue using this method(commands): use MyDbName; set global optimizer_switch='derived_merge=off'; set optimizer_switch='derived_merge=off'; However I'm still wonder how I will be able to use MySQL for VS(8.0.12)/connector.net(8.0.12) combination to be up to date? Anyway, for now I am reluctant to try and upgrade those 2 until there is a working solution for me. Regards, Patrick