IrisWebClient – ODBC Installation Guide

/etc/odbc.ini

[ODBC Data Sources]
User = User
Userunixodbc = Userunixodbc

[User]
Driver          = InterSystems IRIS ODBC35
Description     = IRIS ODBC driver
Host            = localhost
Namespace       = USER
UID             = odbcuser
Password        = .....
Port            = 1972
Protocol        = TCP
Query Timeout   = 1
Static Cursors  = 0
Trace           = off
TraceFile       = /tmp/iodbctrace.log
Authentication Method   = 0
Security Level  = 2
Service Principal Name = iris/localhost.domain.com

The command to test DSN named User

isql -v User

root@56919de89e9b:/# isql -v User
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| echo [string]                         |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

List all available DSNs

odbcinst -q -s

/etc/odbcinst.ini

This file should contain only driver definitions, not DSNs

[InterSystems IRIS ODBC35]
Description=InterSystems IRIS ODBC Driver
Driver=/home/irisowner/bin/libirisodbcuw35.so
Setup=/home/irisowner/bin/libirisodbcuw35.so
UsageCount=2

Example: FireDAC using IRIS ODBC Driver in Delphi

  with Connection do begin
      DriverName := 'ODBC';
      Params.Add('DriverID=ODBC');
      Params.Add('DataSource=User');
      Params.Add('UID=odbcuser');
      Params.Add('PWD=.....');
      Params.Add('ODBCAdvanced=Server=localhost;Port=1972;Namespace=USER;');
      LoginPrompt := False;
	  Connected := True;
   end;