我正在尝试连接到MS SQL数据库。这是我的代码:
void Start ()
{
string connectionString =
"Server=MyServer;" +
"Database=Data;" +
"User ID=User;" +
"Password=psd;" +
"Integrated Security=SSPI";
Debug.Log("conn string");
List<int> result = new List<int>();
string sql = "SELECT RecordCount FROM MainDB";
IDbConnection dbcon;
dbcon = new SqlConnection (connectionString);
dbcon.Open ();
IDbCommand dbcmd = dbcon.CreateCommand ();
dbcmd.CommandText = sql;
IDataReader rdr = dbcmd.ExecuteReader ();
while (rdr.Read()) {
result.Add ((int)rdr.GetValue(0));
}
Debug.Log("get");
// clean up
rdr.Close ();
rdr = null;
dbcmd.Dispose ();
dbcmd = null;
dbcon.Close ();
dbcon = null;
}
我从单调项目中复制了大部分代码。我在防火墙规则中允许UDP端口1434和mono.exe。IAM仍然收到消息:
notimplemplededException:单声道不支持名称管道或共享 连接到SQL Server的内存。请启用TCP/IP 协议。 system.data.sqlclient.sqlconnection sqlmonitorsocket.discovertcpport (INT32超时) system.data.sqlclient.sqlconnection.discovertcpportvortviasqlmonitor (System.String Servername,System.String InstancEname) system.data.sqlclient.sqlconnection.parsedatasource(System.String TheDatasource,System.Int32&amp;Theport,System.String&amp;该名称) system.data.sqlclient.sqlconnection.open()connecttodb.start()(at 资产/connecttodb.cs:33)
我缺少什么?
如果您需要建立TCP/IP插座的帮助,您可以流行的第三方解决方案,例如SmartFox服务器或Photon。