# Installation and Configuration of ODBC Driver

If you have installed a MySQL database (according to one of the previous chapters), continue with the ODBC configuration.

For EaInfoport to work, Enterprise Architect needs to have data saved in a relational database (not just in .eap file).  
ODBC drivers are required to connect Enterprise Architect and the database. They are freely available for all supported database types.  
Below is a detailed procedure for MySQL, for other databases the procedure is similar.

### ODBC Installation for MySQL

- Download the installation file for the **32-bit** version from the **5.x.x series** from [https://downloads.mysql.com/archives/c-odbc/](https://downloads.mysql.com/archives/c-odbc/). So currently mysql-connector-odbc-5.3.13-win32.msi.  
    Save the file, for example, to the folder *C:\\EAInfoport\\Dataprojekt*
- Start the installation, confirm the licence, complete the installation  
    Delete the installation file

### ODBC Configuration for MySQL

- Start the ODBC connection management application “**ODBC Data Sources (32-bit)**”
- Switch to the **User DNS** tab (attention: important!)
- Add a new Data Source type “MySQL ODBC 5.3 ANSI Driver”
- Fill in the connection parameters according to the following pattern (and according to the values you entered when installing the MySQL database), and **do not forget the Detailed Settings**
    - *Data Source Name = ea*
    - *TCP/IP Server = localhost*
    - *User = infoport*
    - *Password = P@ssw0rd*

*[![mysql-connector-1111.png](https://doc.eainfoport.cz/uploads/images/gallery/2022-04/scaled-1680-/mysql-connector-1111.png)](https://doc.eainfoport.cz/uploads/images/gallery/2022-04/mysql-connector-1111.png)*

**Connection** tab

- Check *Allow big result sets*
- Check *Allow multiple statement*

*[![mysql-connector-1upraveno.png](https://doc.eainfoport.cz/uploads/images/gallery/2022-04/scaled-1680-/mysql-connector-1upraveno.png)](https://doc.eainfoport.cz/uploads/images/gallery/2022-04/mysql-connector-1upraveno.png)*

**Cursors/Results** tab

- Check Return *matched rows instead of affected rows*

*[![microsoftteams-image-1-opraveno.png](https://doc.eainfoport.cz/uploads/images/gallery/2022-04/scaled-1680-/microsoftteams-image-1-opraveno.png)](https://doc.eainfoport.cz/uploads/images/gallery/2022-04/microsoftteams-image-1-opraveno.png)*

**Misc** tab

- Check *Prepare statements on the client*

*[![microsoftteams-image-2upraveno.png](https://doc.eainfoport.cz/uploads/images/gallery/2022-04/scaled-1680-/microsoftteams-image-2upraveno.png)](https://doc.eainfoport.cz/uploads/images/gallery/2022-04/microsoftteams-image-2upraveno.png)*

- Save the settings
- Now you can close the ODBC Data Source Administrator application (32-bit)