In this post, I will explain how one can add MySQL server into  MS SQL server 2005 as linked server.

Here are the steps to follow.

1. Install Mysql connector odbc driver.

2. create DSN with mysql driver with database/table from Mysql server

3. create linked server with provider- Microsoft oledb provider forODBC drivers.

    You can select & insert records using mysql linked server in sql server

e.g.
  suppose test is system dsn created using Mysql connector odbc driver and MYSQL is linked server.

then by using following queries you can select & insert records from mysql using sql server query analyzer

for selecting--

select * from openquery
(MYSQL,'select * from testing.linktestmsql')

for inserting--

INSERT INTO OPENQUERY(MYSQL,'select * from testing.linktestmysql')
SELECT * FROM linktest
 

**note--
MYSQL is ny Linked server name here and test is my DSN name.

linktestmysql is table from database testing from mysql server

linktest is table from sql server.


- Vinayak