This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 57.99999999999999%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I compiled a program using UNITY to communicate with a MySQL database and retrieve data. When I ran the program in the UNITY editor, I was able to establish a connection to the database. However, when I published the program to HOLOLENS2 and ran it, there were no error messages, but communication was not established. In the program log of HOLOLENS, I found the following error. Can you tell me what the problem is and how to solve it?
NotSupportedException: System.Configuration.ConfigurationManager::GetSection
at System.Configuration.ConfigurationManager.GetSection (System.String sectionName) [0x00000] in <00000000000000000000000000000000>:0
at MySql.Data.MySqlClient.MySqlConfiguration..cctor () [0x00000] in <00000000000000000000000000000000>:0
at MySql.Data.MySqlClient.Replication.ReplicationManager..cctor () [0x00000] in <00000000000000000000000000000000>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00000] in <00000000000000000000000000000000>:0
at lunxun.Start () [0x00000] in <00000000000000000000000000000000>:0
Rethrow as TypeInitializationException: The type initializer for 'MySql.Data.MySqlClient.MySqlConfiguration' threw an exception.
at MySql.Data.MySqlClient.Replication.ReplicationManager..cctor () [0x00000] in <00000000000000000000000000000000>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00000] in <00000000000000000000000000000000>:0
at lunxun.Start () [0x00000] in <00000000000000000000000000000000>:0
Rethrow as TypeInitializationException: The type initializer for 'MySql.Data.MySqlClient.Replication.ReplicationManager' threw an exception.
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00000] in <00000000000000000000000000000000>:0
at lunxun.Start () [0x00000] in <00000000000000000000000000000000>:0
Exception: 连接失败！The type initializer for 'MySql.Data.MySqlClient.Replication.ReplicationManager' threw an exception.
at sql.SqlAccess..ctor (System.String host, System.String port, System.String username, System.String pwd, System.String database) [0x00000] in <00000000000000000000000000000000>:0
at lunxun.online1 () [0x00000] in <00000000000000000000000000000000>:0
hello. can you post your MySQL connection script? (please remove all sensitive info like user/pass from it).
it might be that the MySQL nuget package you are using or some of its methods are not compatible with UWP.
We have a sample documentation on how to connect to MySQL from UWP Use a MySQL database / UWP
Thank you very much for replying to my question. Here is the code. It's just a simple communication with MySQL, but it hasn't implemented the function. I tried to find the problem, but unfortunately, I'm a beginner.
Thank you very much for replying to my question. Here is the code. It's just a simple communication with MySQL, but it hasn't implemented the function. I tried to find the problem, but unfortunately, I'm a beginner.
Copy
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Data;
using sql;
public class lunxun : MonoBehaviour
{
// Start is called before the first frame update
public string host = "XXXXXXX";
public string port = "XXXX";
public string username = "XXXXXX";
public string pwd = "XXXXXXX";
public string database = "XXXXXXX";
public GameObject connection;
private MySqlConnection conn;
bool q = false;
void Start()
{
try
{
string connStr = "server=XXXXXXX;user=XXXXXX;database=XXXXXXX;port=XXXX;password=XXXXXXX;";
conn = new MySqlConnection(connStr);
conn.Open();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
switch (ex.Number)
{
case 0:
Debug.Log("Cannot connect to server. Contact administrator");
break;
case 1045:
Debug.Log("Invalid username/password, please try again");
break;
}
}
StartCoroutine(MonitorTValue());
online1();
}
IEnumerator MonitorTValue()
{
while (true)
{
string sql = "SELECT communication FROM temporary where id = 1";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int T = rdr.GetInt32(0);
if (T == 0)
{
q = false;
}
else if (T == 1)
{
q= true;
}
}
rdr.Close();
yield return new WaitForSeconds(1f);
}
}
void X()
{
if (q == true)
{
connection.SetActive(true);
communication0();
q = false;
}
}
// Update is called once per frame
void Update()
{
X();
}
public void online1()
{
SqlAccess sql = new SqlAccess(host, port, username, pwd, database);
string sqlname = string.Format("update temporary set online=1 where id=1;");
DataSet save = sql.SaveAll(sqlname);
sql.Close();
}
public void communication0()
{
SqlAccess sql = new SqlAccess(host, port, username, pwd, database);
string sqlname = string.Format("update temporary set communication=0 where id=1;");
DataSet save = sql.SaveAll(sqlname);
sql.Close();
}
I tried to install MySql.Data from the NUGET package manager console in VS, but failed. The error message is: Severity Code Description Project File Line Suppression State Error - Unable to install package 'MySql.Data 8.0.32.1'. You are trying to install this package into a project that targets 'native, Version=v0.0', but the package does not contain any assembly references or content files that are compatible with that framework. For more information, contact the package author. I am not sure what caused this situation.
Thank you very much for replying to my question. Here is the code. It's just a simple communication with MySQL, but it hasn't implemented the function. I tried to find the problem, but unfortunately, I'm a beginner.
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Data;
using sql;
public class lunxun : MonoBehaviour
{
// Start is called before the first frame update
public string host = "XXXXXXX";
public string port = "XXXX";
public string username = "XXXXXX";
public string pwd = "XXXXXXX";
public string database = "XXXXXXX";
public GameObject connection;
private MySqlConnection conn;
bool q = false;
void Start()
{
try
{
string connStr = "server=XXXXXXX;user=XXXXXX;database=XXXXXXX;port=XXXX;password=XXXXXXX;";
conn = new MySqlConnection(connStr);
conn.Open();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
switch (ex.Number)
{
case 0:
Debug.Log("Cannot connect to server. Contact administrator");
break;
case 1045:
Debug.Log("Invalid username/password, please try again");
break;
}
}
StartCoroutine(MonitorTValue());
online1();
}
IEnumerator MonitorTValue()
{
while (true)
{
string sql = "SELECT communication FROM temporary where id = 1";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int T = rdr.GetInt32(0);
if (T == 0)
{
q = false;
}
else if (T == 1)
{
q= true;
}
}
rdr.Close();
yield return new WaitForSeconds(1f);
}
}
void X()
{
if (q == true)
{
connection.SetActive(true);
communication0();
q = false;
}
}
// Update is called once per frame
void Update()
{
X();
}
public void online1()
{
SqlAccess sql = new SqlAccess(host, port, username, pwd, database);
string sqlname = string.Format("update temporary set online=1 where id=1;");
DataSet save = sql.SaveAll(sqlname);
sql.Close();
}
public void communication0()
{
SqlAccess sql = new SqlAccess(host, port, username, pwd, database);
string sqlname = string.Format("update temporary set communication=0 where id=1;");
DataSet save = sql.SaveAll(sqlname);
sql.Close();
}
This doesn't seem to be related to Hololens. The ConfigurationManager class is not supported by Unity's IL2CPP scripting backend. You can read here about System.Configuration.ConfigurationManager. This is because ConfigurationManager relies on the System.Configuration namespace, which is not included in the subset of the .NET Framework that's supported by IL2CPP.