How to configure ODBC connection to connect to MYSQL database:
Step1. Go to start menu and select control panel.
Step2. Open Administrative tool.
Step3. Open data sources (ODBC)
Step4. Under the User DSN tab select “ADD” to add a new data source.
Step5. In the “create new data source” dialogue box select MYSQL ODBC driver (To connect to the MYSQL database) and click “Finish”.
Step6. In the MySQL ODBC Driver - DSN Configuration dialogue box enter the following details:-
(a) Data Source Name: Give a name to the data source
(b) Description: Give a description to the data source
(c) Host/Server Name(or IP Address): Give the host server name or IP address where the MYSQL is installed
(d) Port: Server port used to access MySQL (3306)
(e) User: Give the authentication (User name) details to connect to the server and database.
(f) Password: Give the authentication (password) to connect to the server and database.
(g) Database Name: Give the database name where you want to connect.
Step7. You can now test the connection to see if this connection is successful or not. If the connection is not successful then perform the step6 again with the correct details.
