ODBC Administration

You can access databases in Eggplant Functional using the Microsoft Open Database Connectivity (ODBC) protocol. Using ODBC requires three things:

ODBC driver: This allows Eggplant Functional and the target database to communicate. You must install the appropriate driver for the type of database you want to access. Install this driver on the machine where you run Eggplant Functional, and make sure it is the same version (32-bit or 64-bit) as your installation of Eggplant Functional.

OCBC driver manager: This manages the ODBC driver and allows Eggplant Functional to load and use the ODBC driver.

Data Source Name (DSN) definitions: These specify the connection information for your specific database, and can include the server name, IP address, port, and credentials.

There are different requirements for using ODBC based on the operating system you're working with.

Windows

The ODBC driver manager on Windows is called the ODBC Data Source Administrator. It manages and loads the ODBC drivers, and it also provides a graphical user interface (GUI) where you can configure DSNs. Windows 7, Windows 8, and Windows 10 provide an ODBC administrator for both 32-bit and 64-bit applications. Use the appropriate administrator for your installation of Eggplant Functional:

  • The 32-bit ODBC Administrator: C:\Windows\SysWOW64\odbcad32.exe. This is where the 32-bit drivers are listed when configuring a data source.
  • The 64-bit ODBC Administrator:C:\Windows\system32\odbcad32.exe.

    Note: The ODBC Administrator is itself a 32-bit application. The drivers it manages can be either 32- or 64-bit, which is why the application exists in different locations.

To connect to MySQL, for example, you’ll need to download a 32-bit or 64-bit ODBC driver.

Mac

Mac operating systems do not include ODBC driver administration software, so you need to install a third-party ODBC manager in addition to any ODBC drivers. We have successfully tested ODBC Manager for Mac, which features a GUI where you can configure your DSNs.

The Eggplant Functional application for Mac is 64-bit, so you must install the 64-bit version of the appropriate ODBC driver for your database.

Linux

Linux releases of Eggplant Functional include an ODBC driver manager, so you don't need to install one. You must install a driver and configure a couple of files.

Download and extract or install the appropriate 64-bit ODBC driver for your target database and the operating system where you have Eggplant Functional (Eggplant Functional for Linux is a 64-bit application).

Create and configure the odbc.ini file (where you create DSNs) and the odbcinst.ini file (where you specify driver installation locations) in the /etc directory, which is where Eggplant Functional expects them. For more information about configuring DSNs, refer to the Microsoft documentation or the documentation for your ODBC driver and database.

 

This topic was last updated on June 21, 2019, at 02:49:49 PM.

Eggplant icon Eggplantsoftware.com | Documentation Home | User Forums | Support | Copyright © 2019 Eggplant