- Home /
Connection issues with C# and MySql using Mono.
For a personal project I am trying to use MySQL to access a database I have created which stores images. I am coding my scripts in C# but my connection refuses to open. Here is a snippet of my code (the relevant portion):
using MySql.Data.MySqlClient;
string cs ="Server=localhost;Database=test;Uid=root;Pwd=password;";
MySqlConnection conn = null;
MySqlDataReader rdr = null;
try
{
conn = new MySqlConnection(cs);
conn.Open();
string stm = "SELECT * FROM images";
MySqlCommand cmd = new MySqlCommand(stm, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
//do stuff
}
} catch (Exception ex)
{
print (ex.ToString());
} finally
{
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
I have put in breakpoints and the culprit is the conn.Open() function. At that point it throws an exception:
"System.TypeInitializationException: An exception was thrown by the type initializer for MySql.Data.MySqlClient.MySqlTrace ---> System.MissingMethodException: Method not found: 'System.Configuration.IConfigurationSectionHandler.Create'. at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection (System.String configKey) [0x00000] in :0 at System.Configuration.ConfigurationManager.GetSection (System.String sectionName) [0x00000] in :0 at System.Configuration.ConfigurationSettings.GetConfig (System.String sectionName) [0x00000] in :0 at System.Diagnostics.DiagnosticsConfiguration.get_Settings () [0x00000] in :0 at System.Diagnostics.TraceSource..ctor (System.String name, SourceLevels sourceLevels) [0x00000] in :0 at System.Diagnostics.TraceSource..ctor (System.String name) [0x00000] in :0 at MySql.Data.MySqlClient.MySqlTrace..cctor () [0x00000] in :0
--- End of inner exception stack trace --- at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in :0 UnityEngine.MonoBehaviour:print(Object) UIScript:Start() (at Assets/UIScript.cs:123)"
It sounds to me like an old/mismatched dll but I brought in MySql.Data, I18N, and I18N.West as a couple of solutions suggested while I was googling. I have run out of suggested fixes and I hope someone can help.
EDIT) My database exists according to Workbench.
Your answer
Follow this Question
Related Questions
Distribute terrain in zones 3 Answers
mono in unity 3d and .net remoting 0 Answers
Multiple Cars not working 1 Answer
5DT Glove- COM port not opening 1 Answer
A node in a childnode? 1 Answer