Connect to MySQL database from SQL server

First of all you need to download the MySQL connection / ODBC driver.

The ODBC driver can be download free of charge from the followinglocation:

Folow the simple installation instructions.

In Microsoft SQL Server Management Studio – expand the database tree on the left hand side of the window – expand server obects – expand linked servers

Right-click linked servers – click New Linked Server…

Linked server: enter a name for the connection – this can be anything.
Server type: select Other data source
Provider: select Microsoft OLE DB Provider for ODBC Drivers
Product name: This is the name of the MySQL database connecting to

Provider String: This MUST be entered exactly as it appears below, omitting server, database, user and password with your own details.

Driver={MySQL ODBC 3.51 driver}

For Example:
Driver={MySQL ODBC 3.51 driver}

Select the Security tab on the right
select Be made using this security cointext towards the bottomof the screen.
Enter a valid user name and password to cennect to the MySAL server.

Remote login: Admin
with password: pass32w0rd

Select the Server Options tab on the right
Set the details as follows:

Collation Compatible: FALSE
Data Access: TRUE
Rpc Out TRUE
Use Remote Collation TRUE
Connection Timeout 0
Query Timeout 0

Click OK to instantiate the linked server.

One thought on “Connect to MySQL database from SQL server

Leave a Reply

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

You are commenting using your 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