Download Mysql Odbc 5.3 Unicode Driver
MySQL ODBC Connector
ODBC Connector
MySQL ODBC drivers provide access to a MySQL database in a heterogeneous environment using the industry standard Open Database Connectivity (ODBC) API. MySQL Connector/ODBC provides both driver-manager based and native interfaces to the MySQL database, with the full support of MySQL functionality, including stored procedures, transactions and, with Connector/ODBC 5.1 and higher, total Unicode compliance. The post-obit section describes how to install, configure, and develop database applications using MySQL Connector/ODBC in Windows, Linux, Mac OS X, and Unix platforms
Windows
Before installing the Connector/ODBC drivers on Windows :
- Brand certain your Microsoft Data Admission Components (MDAC) are up to date. Download the latest version fromMicrosoft Data Access and Storage.
- Make certain yous have the Microsoft Visual C++ 2010 Redistributable Package installed on your system. Download the latest version from
Microsoft Download Center.
Download Connector/ODBC :
You tin download the latest version of Connector/ODBC binaries and sources from the following website :
http://dev.MySQL.com/downloads/connector/odbc/.
Binary or Source Installation Method :
You lot can install the Connector/ODBC drivers using two different methods, binary installation or source installation. The binary method is like shooting fish in a barrel which is a parcel of necessary libraries and other files pre-built, with an installer program. The source installation method is important where you want to customize or modifies the installation process or for those platforms where a binary installation package is not available.
Installing the Windows Connector/ODBC Driver:
Select and download the zipped or MSI installer packages from
http://dev.MySQL.com/downloads/connector/odbc/
as per your requirement. The basic installation process is same for both installers.
At present follow the post-obit steps :
Step -1:
Double click the installer (here it is ‘MySQL-connector-odbc-v.3.ii-win32.msi’)
Click on ‘Run’.
Stride -two:
This is the Setup Wizard for MySQL Connector/ODBC 5.3, Click ‘Next’.
Footstep -three:
License agreement : Read the license agreement, either have or deny.
Accept the terms of the license agreement.
Step -4:
Select ‘Typical’, ‘Consummate’ or ‘Custom’ as per your requirement.
Select ‘Typical’ and click ‘Side by side’.
Footstep -5:
Now the wizard is prepare to begin the installation. Click on ‘Install’.
Step -6:
Click on ‘End’ to complete the process.
The installation process has completed, now we volition configure the ODBC connections.
Pace-1: On the Starting time menu (windows 7), choose Command Panel\Arrangement and Security\Administrative Tools, and and then click Data Sources (ODBC).
Step-2: Click on ‘add together ‘ and select MySQL ODBC 5.three ANSI Driver
Step-3: Now you demand to configure the specific fields for the DSN you are creating through the Connection Parameters dialog.
- Data Source Name : Input a valid name of the information source to admission.
- Clarification : Input some text to identify the connexion.
- TCP/IP Server : Input the name of the MySQL server host to access. By default, information technology is localhost.
- User: Input the user name to use for this connection.
- Password: Input the respective password for this connection.
- Database: The database pop-upward should automatically populate with the list of databases that the user has permissions to admission.
- Port: To communicate over a different TCP/IP port than the default (3306).
Pace-4: Now input the valid data in specific fields and click on ‘Test’ button to examination the connection.
Pace-v: Yous can configure a number of options for a specific DSN by using the ‘Details’ button.
To use Secure Sockets Layer (SSL) when communicating with MySQL server y’all must specifiy the following boosted information.
Example: Using Connector/ODBC with Microsoft Word, Excel or Admission
Yous can employ Microsoft Excel, Word to access data from a MySQL database using ODBC. Within Microsoft Excel or Discussion there are facilities to import data from MySQL database. Run across the following instance.
Pace-one: Be sure that your MySQL server is running. Here nosotros are using MySQL v.six.
Stride-2: Create a new worksheet. Here nosotros are using Microsoft Function Excel 2007.
Footstep-3: From the Data menu, click on ‘From other sources’ and then click on ‘Information Connection Magician’, the post-obit window will come :
Select ‘ODBC DSN’ and Click ‘Next’
Pace-4: From ODBC data sources select ‘MySQL’ and click ‘Next’
Footstep-5: Now select databases and tables.
Footstep-6: Allow select database ‘sakila’ and ‘customer_list’ tabular array and click ‘Next’.
Step-vii: Input a name and description for your new Data Connectedness, and press ‘Terminate’ to relieve.
Footstep-8: Select how you desire to view this data in your workbook (e.g. Table, PivotTable Report etc).
Let select ‘Table’.
Output (partial data):
Previous:
MySQL Connector and APIs Introduction
Side by side:
MySQL Python Connector