ODBC Install & Configuration
MySQL 5.3.6 ODBC Driver Install
- Download the MySQL ODBC 5.3.6 Driver for your OS from here
- Install the Driver, follow the instructions provide by MySQL found here
Adding MySQL 5.3.6 ODBC Driver as a Data Source
From the Windows Desktop:
- Click “Start”
- Search for “ODBC”
- Under Programs you should see “Data Sources (ODBC)”
- From there click, “System DSN”
- Click “Add”
- Choose “MySQL ODBC 5.2 Unicode Driver”
- Click “Finish”
MySQL ODBC Data Source Configuration
Now that you have the driver installed successfully, you will need to configure it.
- You will need MIE’s CA, you can download from here: Med-Web SSL CA
- You should have received an e-mail containing information on how to obtain the follow elements for configuration:
- Port: 3306
- SSL Key
- SSL Cert
- SSL CA
- SSL Cipher
From the MySQL ODBC Configuration Screen
- Click “Details »” for advanced options.
- Click “SSL Settings”
- Fill in all fields provided from the configuration e-mail sent to you.
- Test connection by clicking “Test”.
- Insure that your certificates and keys are in the correct inputs.
3rd Party Tools
There are many tools out there that can utilize an ODBC connection. This section is to help configure the most common ones.
Crystal Reports 2008
Crystal Reports is a very powerful report tool that can be used in conjunction with the WebChart ODBC connection to generate complex reports. This section is to help you configure Crystal Reports 2008 and fix a performance problem that will help speed up the mapping of tables and their relations.
- Install Crystal Reports 2008
Turn Off Crystal’s Smart Linking
Before you run Crystal Reports 2008, simply download the registry fix to turn off Crystal’s Smart Linking.
- Download this file Crystal10TurnOffSmartLinking.reg by right clicking and choosing “Save As”. Save the file to the “MIE ODBC” directory that you created earlier.
- From the Windows desktop
- Click “Start”
- Click “Run…”
- Type “regedit” in the Open input box.
- Click “Ok”
- The Registry Editor will launch
- Click “File”
- Click “Import”
- “Import Registry File” dialog will pop.
- Navigate to the “MIE ODBC” folder that you saved the “Crystal10TurnOffSmartLinking.reg” file.
- Choose “Crystal10TurnOffSmartLinking.reg”
- Click “Open”
- An information prompt will pop stating that the reg file was imported successfully. If you did not get this, something went wrong. Make sure you choose the right file.
- Done, you have successfully turned off Crystal’s Smart Linking.
- It is now Ok to launch Crystal Reports 2008.