环境：visual studio 2021、Centos7+mysql8.0
我最近在学vb.net，在访问数据库是遇到问题。救命
Imports System
Imports MySql.Data.MySqlClient
Module Program
Sub Main(args As String())
Dim ConStr As String =
String.Format("server={0};user id={1};password={2};database=test1;pooling=false", "192.168.9.192", "w_root", "Aa,,1111")
Dim con As MySqlConnection = New MySqlConnection(ConStr)
con.Open()
Dim redaer As MySqlDataReader
Dim sql As String = "select * from student"
Dim cmd As MySqlCommand = New MySqlCommand(sql, con)
redaer = cmd.ExecuteReader
While (redaer.Read())
Console.WriteLine(redaer.GetString(0))
Console.WriteLine("i")
End While
con.Close()
End Sub
End Module
报错信息：
Unhandled exception. System.TypeInitializationException: The type initializer for 'MySql.Data.MySqlClient.Replication.ReplicationManager' threw an exception.
---> System.IO.FileNotFoundException: Could not load file or assembly 'System.Configuration.ConfigurationManager, Version=0.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. 系统找不到指定的文件。
File name: 'System.Configuration.ConfigurationManager, Version=0.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'
at MySql.Data.MySqlClient.Replication.ReplicationManager..cctor()
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.Replication.ReplicationManager.IsReplicationGroup(String groupName)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at ConsoleApp2.Program.Main(String[] args) in C:\Users\T0014\source\repos\ConsoleApp2\ConsoleApp2\Program.vb:line 9
C:\Users\T0014\source\repos\ConsoleApp2\ConsoleApp2\bin\Debug\net6.0\ConsoleApp2.exe (进程 19672)已退出，代码为 -532462766。
按任意键关闭此窗口. . .
