Answer

How to Connect to MySQL Server?

Aejaz Habib

471

Hi
I need to connect my 'Windows Form Application' to 'Remote MySQL Server'.

I have looked through many sites for the solution. At last I got a promising solution at

https://dev.mysql.com/downloads/connector/net/6.0.html

But on building the solution I the following in ErrorList

Error 40 The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 6 7 Handler.DB

Error 41 The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 7 7 Handler.DB

Error 42 The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 8 7 Handler.DB

Error 43 The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 9 7 Handler.DB

Error 44 The type or namespace name 'MySqlConnection' could not be found (are you missing a using directive or an assembly reference?) D:\DevOps\1\R3Connector\Handler.DB\Handler\MySQLManager.cs 27 29 Handler.DB

I can't understand why on build MySql namespace not detected where as it shows OK while coding and detects all the related classes and functions.

Somebody please help