SECTION 4.4.3

4.4.3 Database Connection Pooling and Caching

To aid in the performance of DATA tags, you may choose to enable ODBC connection pooling and connection caching in RES-Reach.

These features are activated/deactivated by changing registry values. The registry key HKLM/RES International/Reach-32/ODBCOptions can have 4 values:

0	ODBC connection pooling OFF, RES-Reach connection caching OFF.
1	ODBC connection pooling OFF, RES-Reach connection caching ON.
2	ODBC connection pooling ON, RES-Reach connection caching OFF.
3	ODBC connection pooling ON, RES-Reach connection caching ON.

In general, the ODBC drivers for databases like MS Access do not handle connection pooling reliably, so we do not recommend that pooling or caching be activated for them.