As I have successfully created the Linked Server in SQL Server 2012 SP4 with MYSQL Server. Some of the small tables record able to fetch from the MySQL Server. And some of the big tables records when I am going to fetch from that MySQL Server.
For example I am running the query like:
SELECT * FROM OPENQUERY(LinkedServerName, 'SELECT * FROM databasename.tablename'); Go
I am getting the below mention error:
OLE DB provider "MSDASQL" for linked server "LinkedServerName" returned message "[MySQL][ODBC 5.3(a) Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060".
Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LinkedServerName".
Any suggestion or help will be appreciated.