Linkedserver connection to MySQL database with ODBC driver connection issue

[binrip1]

I have setup SQL Server 2014 linked server to connect to MySQL 8 instance and when I run a single openquery insert statement like below it works fine. However, when I run multiple insert statement to insert data to multiple tables like below openquery insert statement it fails with this generic error majority of the time. If I run this statement at off-peak time sometimes it works without any error. Errror;OLE DB provider "MSDASQL" for linked server "LinkedServer" returned message "[MySQL][ODBC 8(w) Driver]Can't connect to MySQL server on 'iport' (10060)".Openquery Insert Statement Used:INSE

Continue reading...