Introduction

This guide demonstrates how to set the ODBC MySQL driver.

Here's a great ODBC setup video created by the team at HowTech.

Here is a link to the source.

Video Overview

Download the proper ODBC driver from MySQL.
  • Download the proper ODBC driver from MySQL.

  • Choose the version according to the operating system that you are running.

Add Comment

Sign in using your existing MySQL account.
  • Sign in using your existing MySQL account.

  • Or, register for a new account with MySQL.

Add Comment

Click Download Now. When your download completes, double click your the .msi file to install the MySQL ODBC driver.
  • Click Download Now.

  • When your download completes, double click your the .msi file to install the MySQL ODBC driver.

Add Comment

Begin the installation process by selecting Next when the MySQL installer appears. Accept the standard MySQL license agreement and click next.
  • Begin the installation process by selecting Next when the MySQL installer appears.

  • Accept the standard MySQL license agreement and click next.

  • Now, you've successfully installed the MySQL driver on your computer. Next, you will setup the connection to your Data Source.

Add Comment

Open up a Run window by hitting the "R" key while holding the "System" (Windows) key. Enter the following text in the run window:
  • Open up a Run window by hitting the "R" key while holding the "System" (Windows) key.

  • Enter the following text in the run window:

    • "control panel"

    • Hit the "OK" button.

  • A new window, the Control Panel, will now appear.

    • Click "System and Security" link at the top of the left column.

Add Comment

In the System and Security section of the Control Panel, Click on the link for Administrative Tools near the bottom.
  • In the System and Security section of the Control Panel, Click on the link for Administrative Tools near the bottom.

Add Comment

Click on ODBC Data Sources. You will want to pick either the 64 bit or 32 bit option based on your computer's processor. When the ODBC window appears select the second tab labeled System DSN.
  • Click on ODBC Data Sources.

    • You will want to pick either the 64 bit or 32 bit option based on your computer's processor.

  • When the ODBC window appears select the second tab labeled System DSN.

  • When you are on the System DSN tab, click Add to begin configuring your ODBC connection.

Add Comment

When the ODBC window appears select the second tab labeled System DSN. When you are on the System DSN tab, click Add to begin configuring your ODBC connection. Click Finish.
  • When the ODBC window appears select the second tab labeled System DSN.

  • When you are on the System DSN tab, click Add to begin configuring your ODBC connection.

  • Click Finish.

Add Comment

The MySQL configuration window will appear and you will have to configure the fields using the credentials provided by your Dozuki Account Manager. If you don't have those credentials please contact your primary Dozuki contact to obtain access. Give your data source a name.
  • The MySQL configuration window will appear and you will have to configure the fields using the credentials provided by your Dozuki Account Manager.

    • If you don't have those credentials please contact your primary Dozuki contact to obtain access.

  • Give your data source a name.

  • For the TCP/IP Server, enter "bi.dozuki.com".

  • The Port should be the MySQL default port: "3306"

  • For User and Password, enter the username and password given to you by your Dozuki account manager.

  • When the above fields are filled out as described, test your connection by clicking the Test button. If successful, click OK.

  • Then select your Database. Your Dozuki account manager should have provided this to you as well.

Add Comment

Your newly created connection should now appear in the list of System Data Sources.
  • Your newly created connection should now appear in the list of System Data Sources.

Add Comment

Conclusion

To reassemble your device, follow these instructions in reverse order.

Dozuki System

Member since: 09/24/2009

1 Reputation

123 Guides authored

0 Comments

Add Comment