Tested with Oracle 12.2 Windows Note: all operations require Administrator access - Install Oracle Instant Client, matching to the server version - edit \network\ADMIN\tnsnames.ora (create directories and file, if not exist) - append this, replace and with correct values (ask database admin if required): orcl = (DESCRIPTION= (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ) ) ) - save and close tnsnames.ora - open Start -> Control Panel -> Administrative Tools -> ODBC Data Sources - select tab "System DSN" - Click "Add..." - select Oracle Instant Client driver - Enter required information: Data Source name: orcl Description: doesn't matter TNS Service Name: orcl User Id: correct user name - optionally: click Test connection, enter correct password, check that "Connection successful" is returned - skip to "Configure Plc Engine" below Linux Note: all operations require root access - install unixODBC package via distibution packet manager - Unpack the Oracle Instant Client, matching to the server version - if required, install the driver by editing odbcinst.ini (usually in /etc/ or /etc/unixODBC/), append: [Oracle 12c ODBC driver] Description = Oracle ODBC driver for Oracle 12c Driver = /libsqora.so.12.1 - save and close - add a new data source in odnc.ini (usually in /etc/ or /etc/unixODBC/) - append this, replace and with correct values (ask database admin if required): [orcl] Application Attributes = T Attributes = W BatchAutocommitMode = IfAllSuccessful BindAsFLOAT = F CloseCursor = F DisableDPM = F DisableMTS = T Driver = Oracle 12c ODBC driver DSN = orcl EXECSchemaOpt = EXECSyntax = T Failover = T FailoverDelay = 10 FailoverRetryCount = 10 FetchBufferSize = 64000 ForceWCHAR = F Lobs = T Longs = T MaxLargeData = 0 MetadataIdDefault = F QueryTimeout = T ResultSets = T ServerName = //:1521/ SQLGetData extensions = F Translation DLL = Translation Option = 0 DisableRULEHint = T UserID = StatementCache=F CacheBufferSize=20 UseOCIDescribeAny=F SQLTranslateErrors=F MaxTokenSize=8192 AggregateSQLType=FLOAT - add or append section [ODBC Data Sources], insert this line: orcl=Oracle ODBC driver for Oracle 12c - save and close odbc.ini - test connection with: `isql -v orcl ` - when the error "Can't open lib '.../libsqora.so.12.1'" appears, the global library path doesn't contain the neccesary path to the oracle installation - to correct this, either: - edit /etc/ld.so.conf, append the oracle installation path; the call `ldconfig` - or edit /opt/plcengine/start.sh, add the oracle installation path to the LD_LIBRARY_PATH=... line; then restart Plc Engine Windows + Linux Now the PLC Engine can be configured: - Run Tani Configuration, connect to PLC Engine - Select Connection List - Click Add Connection - Enter connection name - Select Database Access -> ODBC, click Next - Enter: user name, password - Select ODBC Data source: orcl, click Next - Click Save