Set up an ODBC source in Windows to access your MySQL database at IU RDC

• Overview
• Download and install the MySQL Connector/ODBC driver
• Configure the MySQL ODBC data source
• Get help

Overview

Any program that uses Open Database Connectivity (ODBC) to connect to a remote database needs a way to identify the type of database and the computer to which it is connecting. This is accomplished through the use of an ODBC data source, which associates a name with database connection information.

Following are instructions for setting up an ODBC data source to connect to your MySQL database on the Research Database Complex (RDC) at Indiana University.

Download and install the MySQL Connector/ODBC driver

To configure an ODBC data source for MySQL, you must have the MySQL Connector/ODBC driver installed on your workstation. The MySQL Connector/ODBC driver allows ODBC applications to communicate with MySQL servers.

Following are instructions for downloading and installing the MySQL Connector/ODBC driver (to install the MySQL connector, you must be logged into your workstation as an administrator):

1. Go to Oracle's Download Connector/ODBC page, and under "Generally Available (GA) Releases", make sure Microsoft Windows is the platform selected.
2. From the list of downloads, find the installer file (MSI or ZIP) you prefer for your version of Windows (32- or 64-bit), and then, next to the preferred installer type, click Download.
   Note:

   The MSI files are stand-alone installers that launch setup wizards to step you through the installation process. To use one of the ZIP files, you must extract its contents, and then launch the included batch file (Install.bat) from your workstation's command prompt. In either case, the same software is installed.
3. On the "Begin Your Download" page:
   • To start the download immediately, click No thanks, just start my download.
   • To log in with an existing Oracle Web account before starting the download, click Login using my Oracle Web account.
   • To create an Oracle Web account before starting the download, click Sign up for an Oracle Web account.
4. Locate and double-click the file you downloaded. If your system asks whether you want to install the program, click Yes.
5. The MySQL Connector/ODBC Setup Wizard will launch; to begin the installation process, click Next
6. Read and accept the License Agreement, and then click Next.
7. Choose the installation type, and then click Next.
   Note:

   Oracle recommends choosing either the Typical or Complete installation option. The Typical option provides the standard files needed to connect to a MySQL database using ODBC. The Complete option installs all the available files, including debug and utility components.
8. On the "Ready to Install" page, click Install.
9. If your system asks whether you want to install the program, click Yes. (If you are not already logged in as an administrator on your workstation, you will be prompted to log in with a local administrator account.)
10. When the files are copied to their final locations, the installation is complete; to exit the installer, click Finish.

Configure and locate an ODBC data source

To create an ODBC data source for your MySQL database on the RDC:

1. From the Windows Control Panel, select Administrative Tools, and then Data Sources (ODBC).
2. In the "ODBC Data Source Administrator" window, select the System DSN tab, and then click Add.
3. The "Create Data Source" window will list two MySQL ODBC drivers (one for ANSI and one for Unicode); select the Unicode driver unless you know you need the ANSI driver, and then click Finish. (The Unicode driver handles data from any character set and, according to the MySQL documentation, is recommended for most users.)
4. In the "MySQL Connector/ODBC" dialog box, next to "Data Source Name", enter a name for this server connection (for example, RDC-MySQL).
5. Optionally, enter a description of the source.
6. Make sure TCP/IP Server is selected.
7. Enter the hostname of the RDC host: sasrdsmp01.uits.iu.edu.
8. For "Port", enter the TCP/IP port: 3306.
9. Next to "User" and "Password", enter the MySQL username and password.
10. From the Database drop-down list, select the database you want to access.
11. To confirm the connection, click Test. If the connection is valid, click OK.
12. The ODBC data source you added will now appear in your System DSN list. To finish your ODBC configuration, click OK.

Get help

For help with MySQL Connector/ODBC Driver, see the MySQL Connector/ODBC Developer Guide.

If you need help connecting to your MySQL database on the RDC, email the RDC Administration team (rdcadmin@iu.edu).

For information about RDC database accounts, see the Databases section of About the Research Database Complex (RDC) at Indiana University.