Cannot initialize the data source object of OLE DB provider

Hi Nilesh,

Thank you for your sugesstion. I fixed the issues and got solution for linked server.

1. Create datasource under system

2. We can create linked server only in sql server installed system. it is not possible to create linked server on remote system.

What happened?

Did you find any solution? If my answer worked for you, please mark it as "Accepted" and close this question.

make sure you have specified server name, user name, passwords correctly and there is no misspelling/typos

make sure the mysql server is not blocking incoming connections from sql server instance

also make sure the ODBC datasource is created under SYSTEM and not under USER