MYSQL Linked server in SQL Server

-> Download the installation file of MySQL Connector/ODBC 5.3 from https://dev.mysql.com/downloads/connector/odbc/5.3.html.

Blog77_1Blog77_2Blog77_3Blog77_4Blog77_5

-> Once installed, create a System DSN in ODBC Data Sources (64-bit) as below,

Blog77_6Blog77_7Blog77_8Blog77_9

-> Select the required database and test the connection to ensure it works.

-> Once the datasource is created. Create a linked server as below,

Blog77_10Blog77_11

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s