如何從Unity連接到數(shù)據(jù)庫(kù)我試圖通過Unity連接到MS SQL數(shù)據(jù)庫(kù)。但是，當(dāng)我嘗試打開連接時(shí)，我收到IOException：連接丟失。我從Unity \ Editor \ Data \ Mono \ lib \ mono \ 2.0導(dǎo)入了System.Data.dll。我使用以下代碼： using UnityEngine;
using System.Collections;
using System.Data.Sql;
using System.Data.SqlClient;
public class SQL_Controller : MonoBehaviour {
string conString = "Server=myaddress.com,port;" +
"Database=databasename;" +
"User ID=username;" +
"Password=password;";
public string GetStringFromSQL()
{
LoadConfig();
string result = "";
SqlConnection connection = new SqlConnection(conString);
connection.Open();
Debug.Log(connection.State);
SqlCommand Command = connection.CreateCommand();
Command.CommandText = "select * from Artykuly2";
SqlDataReader ThisReader = Command.ExecuteReader();
while (ThisReader.Read())
{
result = ThisReader.GetString(0);
}
ThisReader.Close();
connection.Close();
return result;
}
}這是我得到的錯(cuò)誤：IOException: Connection lostMono.Data.Tds.Protocol.TdsComm.GetPhysicalPacketHeader ()Mono.Data.Tds.Protocol.TdsComm.GetPhysicalPacket ()Mono.Data.Tds.Protocol.TdsComm.GetByte ()Mono.Data.Tds.Protocol.Tds.ProcessSubPacket ()Mono.Data.Tds.Protocol.Tds.NextResult ()Mono.Data.Tds.Protocol.Tds.SkipToEnd ()Rethrow as TdsInternalException: Server closed the connection.Mono.Data.Tds.Protocol.Tds.SkipToEnd ()Mono.Data.Tds.Protocol.Tds70.Connect (Mono.Data.Tds.Protocol.TdsConnectionParameters connectionParameters)Mono.Data.Tds.Protocol.Tds80.Connect (Mono.Data.Tds.Protocol.TdsConnectionParameters connectionParameters)請(qǐng)用這種方法忽略任何安全風(fēng)險(xiǎn)，我需要這樣做進(jìn)行測(cè)試，安全性會(huì)在以后發(fā)生。感謝您的時(shí)間。
如何從Unity連接到數(shù)據(jù)庫(kù)
Smart貓小萌
2019-08-28 09:45:17
