How to configure ODBC data source for MySQL

To load or transfer MySQL data through an ODBC provider, a data source name should be configured to connect to an ODBC data source.


Prior to start configuring an ODBC data source, download and install ODBC drivers for MySQL.

Since SSMS is a 32-bit application, only 32-bit ODBC drivers can be downloaded and installed.

To set up a new file data source

1. Open Control Panel > Administrative Tools and run ODBC Data Sources (32-bit).

2. In the ODBC Data Source Administrator dialog that opens, on the User DSN tab, click Add.

Click Add to configure a user data source

3. In the Create New Data Source dialog, select a driver for which you want to set up a data source and click Finish.

Select the driver

4. In the MySQL Connector/ODBC Data Source Configuration that opens, enter the following details and click OK:

  • Name of the data source
  • TCP/IP Server and port you want to connect to
  • User and password
  • Select the database you want to connect to

You can add the other information requested in the dialog or you leave those fields blank.

Select the driver

Optional: Click Test to verify the connection. In the Test Result pop-up informing about the successful connection, click OK.

Verify the connection

5. On the User DSN tab, the configured MySQL data source is displayed.

View the created data source for MySQL