admin管理员组

文章数量:1242804

MySQL 8.0.3 Community Edition VB.NET

I have a module that read data from MS access accdb database and insert to MySQL table. The system is running pretty fine on windows 10 machines but throws the following exception on windows 11 machines.

Inner Exception = {"Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond."}

my connection strings are
// connection string for Access Database

Dim accessConnectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\xxx.accdb;"
// connection string for MySql Database

Dim mysqlConnectionString As String = "server = xxx.xxx.xxx.xxx; user=xxxx; password=xxxx; database=xxxx; Character Set=utf8mb4;port=3306;SslMode=None;ConnectionTimeout=30;"

same connection string is being used many other places/modules in the same project. only data import module throws me this error while executing executeNonQuery command.

windows firewall checked. no issue.

本文标签: