Currently I have an application in Visual Basic .NET 2.0 developed in VS 2005, this application attacks a MySQL using the MySQL.Data.dll 6.3.0.4 connector.
I have created a new MSSQL Server 2012 virtual machine with MySQL 8.0.12.0. where data from the previous version is migrated.
First I checked that the database is correctly installed and that there is access to the MySQL port because using HeidiSQL and I connect and I can work with it without problems
My first test is to use the same connector that was being used until now, the application logically compiles but it does not work, since it does not open the connection to the database because it should use the proper connector of 8.0. 12.0
So I'm going to change the reference of MySQL.Data.Dll from 6.3.4 to 8.0.12.0 which is the one that corresponds, but the vs2005 does a very strange thing to me, and that apparently keeps the version 6.3.4.0 but I get errors of data type not defined.
I would appreciate if someone could give me some clue how to solve this and be able to hook the new connector to the project and refresh it so that it loads the reference correctly.