Configure ODBC Connection
Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database. For more information, see here. This topic describes how to configure an Agiloft database with ODBC. Note that for KBs that are on dedicated hosted servers, this can be done using the JDBC wrapper to establish a connection.
Install MySQL ODBC Driver on the Client Machine
Download ODBC drivers from mysql.com and install them on your client machine.
Be sure to pick the correct driver version that corresponds to your operating system. Choose Typical Installation if given a choice by the installer. The installation is rather straightforward, but you can also refer to these links for help with specific operating systems.
Configure ODBC Data Source
After installation the ODBC data source has to be configured for Agiloft database. The following documents describe how to configure the data source on different operating systems:
You might want to configure the data source as System - available to all users. The important thing to remember is to specify the correct user, password and port.
Be sure to test the connection. Both Windows and Linux/UNIX connection managers provide this functionality.
Connect from your Client Application
Once the DSN has been configured, most applications will display it among others in a list of available DSN's.