koobas.hobune.stream
Not able to connect MS SQL to WebGL Program.
SocketException: An existing connection was forcibly closed by the remote host. I get this error when, I created an empty object "DBConnection" and attached the script DBConnection.cs to it. The function "connectDB()" is called on a button click later.
/***DBConnection.cs***/
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using System;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using UnityEngine.UI;
using TMPro;
public class DBConnection : MonoBehaviour
{
public TMP_Text DBConnectionStatusText;
public void connectDB()
{
string connectionString = null;
connectionString = @"Data Source=VIRUSLAPPY\SQLEXPRESS;Initial Catalog=OccupancyUat;Integrated Security=SSPI;";
SqlConnection cnn = new SqlConnection(connectionString);
try
{
cnn.Open();
DBConnectionStatusText.text="Connected!!";
cnn.Close();
}
catch (Exception ex)
{
DBConnectionStatusText.text="Error Connecting!!"+ex;
Debug.LogException(ex, this);
}
}
}
I know this might not be the safe way to connect but couldn't find any material or source with an elaborated explanation of the alternate ways.
