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.

Install MySQL ODBC Driver on the Client Machine

Download ODBC drivers from mysql.com and install them on your client machine.

http://dev.mysql.com/downloads/connector/odbc/

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, the following articles may be helpful as reference for various OS's.

Windows XP operating system: http://www.netadmintools.com/art429.html.

UNIX and Linux: http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-installation-binary-unix.html.

Configure ODBC datasource

After installation the ODBC datasource has to be configured for Agiloft database. The following documents describe how to configure the datasource on various OS. http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration.html.

Windows XP operating system: http://www.netadmintools.com/art430.html.

Linux: http://www.easysoft.com/developer/interfaces/odbc/linux.html.

You may want to configure the datasource 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.