Cannot initialize the data source object of OLE DB provider

Question

Hi all,

 

I am creating linked server from my SQL server 2014 for MySQL database using ODBC driver, but I am getting error

 

 

"Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MYSQL".

OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)"

 

Please let me know any suggestion or solution on it