Creating ODBC Data Source (Windows Plans)
This article will explain how to install a new ODBC driver, for this you have to create a connection to an external database:
This can be done just following the procedure as given below:
1. Navigate to Server >> ODBC Data Sources.
2. Then click Add New ODBC DSN.
3. Describe the ODBC connection name and description in the corresponding fields.
4. Choose the required driver in the Driver field.
5. Then click on OK.
6. Choose the suitable choices on the driver configuration screen. Typically, you must specify the path to the database, user credentials, and different connection options, depending on the chosen driver. To check whether or not the connection will function properly Click test with provided settings.
7. Once done you can click Finish to complete the creation.