x


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

Hello,

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=2.0.0.0, 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

I18N.dll
I18N.West.dll
MySql.Data.dll
System.Data.dll

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

Any suggestions?

Thanks in advance

Joel

more ▼

asked Oct 06, 2010 at 01:40 PM

jsr2k1 gravatar image

jsr2k1
233 24 17 27

(comments are locked)
10|3000 characters needed characters left

2 answers: sort voted first

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!

Joel

more ▼

answered Oct 28, 2010 at 02:56 PM

jsr2k1 gravatar image

jsr2k1
233 24 17 27

(comments are locked)
10|3000 characters needed characters left

you are the boss!

more ▼

answered Sep 16 at 08:51 PM

NikoBusiness gravatar image

NikoBusiness
106 1 3

(comments are locked)
10|3000 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Topics:

x189
x175
x165

asked: Oct 06, 2010 at 01:40 PM

Seen: 4928 times

Last Updated: Sep 16 at 08:51 PM