Why are my ODBC-ODBC Bridge connections to Microsoft SQL Server so slow?

Microsoft introduced changes to SQL Server 7.0 that can cause Easysoft ODBC-ODBC Bridge connections to be very slow. These settings elevate the priority of SQL Server to such an extent that other processes on the machine don't get enough resources to be responsive. If you're using Microsoft SQL Server 7.0 and the ODBC-ODBC Bridge server is running on the same machine as SQL Server, try the following:

  1. Turn off the Boost SQL Server Priority on Windows NT and Use NT fibres settings. When these are turned on, NT is so busy servicing SQL Server, the accept() in the ODBC-ODBC Bridge server can take some time, because NT doesn't schedule any other process time. These settings are available from Enterprise Manager > Properties.
  2. Move your ODBC-ODBC Bridge server to another machine where Microsoft SQL Server is not running.