Easysoft ODBC-ODBC Bridge

Why are my connections to Microsoft SQL Server so slow?

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

• Products
  • Easysoft ODBC-ODBC Bridge
• Databases
  • Microsoft SQL Server

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•