Compiler error with MySQL connection in Unity 3 (System.Drawing)


I have a problem with a script to connect to a DataBase with MySQL. It works ok in Unity 2.6.1, but it doesn't work in Unity 3. I read in forums that "System.Drawing" is not supported in Unity 3.

This is the error:

Internal compiler error. See the console log for more information. output was: Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'System.Drawing, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies.

This is my script:

using UnityEngine;
using MySql.Data.MySqlClient;
using System;
using System.Data;
using System.Collections.Generic

public class NewBehaviourScript : MonoBehaviour 
  void Start () 
    string connectionString = [.....]  //Hidden for security

    MySqlConnection dbConnection = new MySqlConnection(connectionString);

I also copied the next files to the Assets folder of my project


The problem is that the file "MySql.Data.dll" includes System.Drawing

Any suggestions?

Thanks in advance


The solution is:

Copy only the file "MySql.Data.dll" from c:\Program Files (x86)\MySQL\MySQL Connector Net 6.0.3\Assemblies\ to the Assets folder of your project

and change: Player Settings-->Optimization-->Api Compatibility Level = .NET 2.0

That's it!


you are the boss!