Page tree
Skip to end of metadata
Go to start of metadata

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.