SQL Server link servers to MySQL

1> Configuring the Data source Msdasql (System data Source)

2> Open Services service distributed Transaction Coordinator

3>

EXEC sp_addlinkedserver
@server = ' MYSQL ',--this is the name of the linked server
@srvproduct = ' MySQL ',--this is your own free
@provider = ' Msdasql ',--this is fixed, not blind, or dead.
@datasrc = ' Mysqlodbc ',--this is ODBC inside the data source name
@location =null,
@provstr = ' Driver={mysql ODBC 5.3 DRIVER}; Server=mysqlip;database=mysqllogindata; Uid=mysqlloginname; port=3306; ',--this string you'll know by studying it.
@catalog = NULL

EXEC sp_addlinkedsrvlogin
@rmtsrvname = ' MYSQL ',--this is the name of the linked server
@useself = ' false ',
@rmtuser = ' Mysqlloginname ',
@rmtpassword = ' MYSQLLOGINPASSWPRD ';

Problems:

error:7303:

Solve:

Configuring ODBC, and then configuring the linked server for SQL Server, also requires that OLE DB provider be configured on the linked server.

error:7399:

Description: Cannaot initalize ODBC Data Object .......

Solve:

After the data source confirms that there is no problem:

Test succeeded after successfully returning user SA using Windows Authentication logon test

SQL Server link servers to MySQL