MySql Database Connection

[anon_43687934]

I am connecting to a MySql database (5.0.77) via the MySql.data.dll(version 5.1.6 or 5.2.7). I am able to open a connection to the database when I run my game in the editor. However, when I create a build (either webplayer or windows standalone) it is not able to open the connection and it dies with the following error/stack trace.

NotSupportedException: CodePage 1252 not supported
System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[ ] parameters, System.Globalization.CultureInfo culture) [0x00000]
System.MonoType.InvokeMember (System.String name, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object target, System.Object[ ] args, System.Reflection.ParameterModifier[ ] modifiers, System.Globalization.CultureInfo culture, System.String[ ] namedParameters) [0x00000]
System.Type.InvokeMember (System.String name, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object target, System.Object[ ] args) [0x00000]
UnityEngine.SetupCoroutine.InvokeMember (System.Object behaviour, System.String name, System.Object variable) at System.Text.Encoding.GetEncoding (Int32 codePage) [0x00000]
MySql.Data.MySqlClient.Driver…ctor (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings)
MySql.Data.MySqlClient.NativeDriver…ctor (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings)
MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings)
MySql.Data.MySqlClient.MySqlConnection.Open ()

I have checked to see if the dll’s (MySql.Data.dll and System.data.dll) included in the standalone build are the same version as those included in unity, and they are. I have also made sure that these two dll’s are included in a subfolder of the projects Assets directory.

This occurs on both unity 2.5 and 2.6.

How can I solve this problem and get the connection to mysql database to open via a standalone or webplayer build?

[AnomalusUndrdog]

Hi. I’m not sure about the problem but looking over here might help.
http://forum.unity3d.com/viewtopic.php?t=12180&postdays=0&postorder=asc&start=15

They had a similar problem which was solved by including some dlls called I18N.dll and I18N.West.dll in the assets folder.

[MatthewW]

Your best bet is to talk to an intermediary via the WWW class (some server-side script that does the actual communication with the database). This is more compatible–you can deploy to the web player–and also more secure.

[anon_43687934]

As suggested by anomalous_underdog, the solution to this problem is to add the I18N.dll and the I18N.West.dll to the assets folder of unity (I grabbed these from the Mono.Framework folder in unity). This will cause these two dll’s to be included in the Standalone build, and connects can then be opened to the database.

Thank you for all of your help!

[anon_72990343]

@anon_43687934

As suggested by anomalous_underdog, the solution to this problem is to add the I18N.dll and the I18N.West.dll to the assets folder of unity (I grabbed these from the Mono.Framework folder in unity). This will cause these two dll’s to be included in the Standalone build, and connects can then be opened to the database.

Thank you for all of your help!

thank you very much