Iguana supports PostgreSQL on Unix/Linux platforms through ODBC. Iguana utilizes the shared library of an ODBC manager, which in turn utilizes the shared library of PostgreSQL’s ODBC driver.
If your installation of PostgreSQL does not include an ODBC driver, you may download psqlodbc, which is the official PostgreSQL ODBC driver. Furthermore, if you do not already have an ODBC driver manager, you may download unixODBC, which is a popular ODBC driver manager distributed under GPL and LGPL.
Although unixODBC includes a PostgreSQL ODBC driver, some features utilized by Iguana weren’t supported by the included driver. Therefore, it is recommended that the latest version of psqlodbc be installed. Additionally, please ensure that the odbc.ini file utilized by the ODBC driver manager is configured to link to psqlodbc and not to some other PostgreSQL ODBC driver.
Two environment variables need to be configured for proper ODBC support on Unix/Linux. The LD_LIBRARY_PATH (or the equivalent dynamic linker variable for your platform) will need to include the absolute path to the ODBC driver manager’s shared library. Also, unixODBC requires an ODBCSYSINI environment variable to point to the directory that contains the odbc.ini file.
The name of the shared object that Iguana is looking for will vary depending on the platform:
|Platform||Library name||Dynamic Linker Env Variable|
|Windows||odbc32.dll||PATH (usually for Windows things just work with ODBC)|
|Linux and others||libodbc.so||LD_LIBRARY_PATH|
>cd /usr/lib64 >ln -s libodbc.so.1 libodbc.so
- The Environmental Variables Settings page to set these environmental variables, and
- The database settings page to see the location of the ODBC library that Iguana has managed to, or not managed to load.
A big motivation for those screens was to aid in diagnosing exactly these kinds of setup issues.
There are UnixODBC drivers for connecting to Microsoft SQL Server and Sybase databases. This link refers to the UnixODBC FreeTDS driver. We have had customers successfully connect to Microsoft SQL Server using Iguana on Linux in this manner.