unixODBC is an ODBC driver manager for UNIX type environments. Instead of linking an application directly with the solidDB® ODBC driver, a unixODBC DriverManager can be used.
For detailed information on unixODBC and the unixODBC DriverManager, see www.unixodbc.org.
Configuration files
The unixODBC DriverManager loads the correct data source driver according to the specifications in the following two configuration files:
▪odbc.ini or .odbc.ini: specifies the logical name of the data source and the actual ODBC driver
The odbc.ini file defines the system-level settings that are available to all users. The .odbc.ini file defines user-level settings.
▪odbcinst.ini: connects the logical driver name with its physical location in the file system.
The odbcinst.ini is a system-level file.
In addition to the files above, the solidDB® ODBC Driver needs a client-side solid.ini configuration file where the logical data source name is connected with the a valid solidDB® connect string.
Syntax of the odbc.ini configuration files
The odbc.ini or .odbc.ini file must include at least the following two items for each data source:
▪Logical name of the data source inside brackets, for example [my_solid]
▪Logical name of the actual ODBC driver to be used by using the syntax
Driver=<drivername>
For example
Driver = solid_odbc
An additional description can be added by using the syntax
Description=My first Solid
All additional information is ignored.
Syntax of the odbcinst.ini configuration file
The logical name and the physical location of the ODBC driver must be specified in the odbcinst.ini file as follows:
▪[<the logical name of the driver>], for example, [solid_odbc]
▪Driver = <absolute path to the driver>, for example, Driver = /home/jsmith/sacl2x64.so
Syntax of the client-side solid.ini configuration file
In the client-side solid.ini file, the logical data source name must be connected to a valid solidDB® connect string (network name) as follows:
▪[Data Sources]
▪<the logical data source name> = <connect_string> , for example, my_solid=tcp my_machine 1964
Location of the configuration files
The system-level configuration files, odbc.ini and odbcinst.ini are located in a system level configuration directory, such as /etc/. For example: