. net maui uses Microsoft Data.SqlClients encountered an exception when directly connecting to SQL Server
文虎 樊
0
Reputation points
Microsoft.Data.SqlClient.SqlException (0x80131904): Successfully established a connection with the server, but an error occurred during the login process。 (provider: TCP provider, error: 0 - Success)
HttpClient can be accessed normally
SQL Server has not enabled SSL/TLS encryption
string ConnectionString = "Server=192.168.1.41;database=Db_Test;User Id=users;Password=users;Encrypt=False;TrustServerCertificate=False;";
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = SQLString;
comm.CommandType = CommandType.Text;
comm.CommandTimeout = conn.ConnectionTimeout;
DataSet ds = new DataSet("SQLDataSet");
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = comm;
adapter.Fill(ds, "SQLDataSet");
conn.Close();
return ds;
}
}
catch (Exception ex)
{
Error= ex.Message;
return null;
}
Open permissions
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android">
<application android:allowBackup="true" android:icon="@mipmap/appicon" android:supportsRtl="true" android:networkSecurityConfig="@xml/network_security_config"></application>
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.ACCEPT_HANDOVER" />
<uses-permission android:name="android.permission.CAMERA" />
<uses-feature android:name="android.hardware.camera" />
<uses-feature android:name="android.hardware.camera.autofocus" />
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.MODIFY_AUDIO_SETTINGS" />
<uses-permission android:name="android.permission.RECORD_AUDIO" />
</manifest>
Sign in to answer