Easysoft ODBC-ODBC Bridge

Why are my connections to Microsoft SQL Server so slow?

Last Reviewed:
9th January 2024

Microsoft introduced changes to SQL Server 7.0 that can cause connections from an Easysoft ODBC-ODBC Bridge Server to Microsoft SQL Server to be very slow. These settings elevate the priority of SQL Server to such an extent that other processes on the machine do not get a look in. (E.g. when someone is issuing a SQL query, TaskManager even stops displaying.) If you are running Microsoft SQL Server 7 and the ODBC-ODBC Bridge Server is running on the same machine as SQL Server, you should try the following:

  1. Turn off the "Boost SQL Server Priority on Windows NT" and "Use NT fibres" settings. When these are set, NT is so busy servicing SQL Server, the accept() in the ODBC-ODBC Bridge Server can take some time due to NT not scheduling any other process. These settings are available from the Properties menu of the Enterprise Manager.
  2. Move your ODBC-ODBC Bridge Server to another machine where Microsoft SQL Server is not running.
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)