I’m trying to set up a linked server (from SQL Server 2019 to MySQL). When i click OK to create the new linked server, I received the following SSMS 2019 spasm, Error #7303:

i follow the same method : Create a Linked Server to MySQL from SQL Server.
the error : ERROR

I have tried the latest MySQL ODBC ANSI/Unicode drivers (8.4.0), set up via System DSNs in both the 32- and 64-bit versions of the ODBC Data Source Administrator.Now, I suspect that something screwy is going on with MS SQL Server and/or its OLE-DB Provider (MSDASQL), because:

1. All tests of the System DSNs within the ODBC Data Source Administrator are successful.
2. I can use the database/tables with MySQL Workbensh