Why am I having intermittent problems with a particular ODBC driver when using the JDBC-ODBC Bridge?

Some ODBC drivers are not thread-safe, and, by default, the Easysoft JDBC-ODBC Bridge server for Windows runs multi-threaded. This can cause a number of intermittent problems. Change the JDBC-ODBC Bridge server to run in multi-process mode, so that there is only ever one thread at a time in the ODBC driver.

To make the JDBC-ODBC Bridge server, run multi-process instead of multi-threaded, use the Web Administrator:

http://my_server:8031

Choose Configuration > Change. Turn on Multi-Process and then choose Submit.

We recommend that you do this for these ODBC drivers: Microsoft Access, Freedom Intelligence, and Navision.