Easysoft ODBC-ODBC Bridge

Why does my second connection to Microsoft Access hang?

Easysoft have seen problems making more than one simultaneous connection from UNIX through the Easysoft ODBC-ODBC Bridge to the Microsoft Access ODBC driver (specifically hanging). We think that the Microsoft Access ODBC driver DLL may contain some shared data that is incompatible with a multi-threaded ODBC-ODBC Bridge server (which is the default configuration). You can work around this problem by changing the ODBC-ODBC Bridge Server to run multi-process instead of multi-threaded.

According to Microsoft's web site:

==========
Known Issue: ODBC Jet driver in multithreaded environments
Component: ODBC Jet driver
When running in a multithreaded or stress environment such as IIS, it is recommended not to use ODBC because
of issues with threading in the driver as well as the Jet engine. The recommendation for this situation
is to work with the OLE DB provider for Jet.
==========

To make the ODBC-ODBC Bridge Server run multi-process instead of multi-threaded, use the ODBC-ODBC Bridge Server administration interface (http://mywindowsmachine:8890). Select Configuration > Change and then choose the MultiProcess checkbox. Click on Submit. If the ODBC-ODBC Bridge Server configuration page has an "AutoUpdateConfiguration" checkbox and it is not checked, you will need to restart the ODBC-ODBC Bridge Server Service. Versions of the ODBC-ODBC Bridge Server administration interface without the "AutoUpdateConfiguration" checkbox do not need the service restarting.

Update to this According to Microsoft's web site, JET 4 is now thread-safe.

You can ascertain if you have JET 4 by clicking on the Drivers tab in ODBC Administrator and examining "Microsoft Access Driver". If it says 4.xxxx then you should not need to switch the ODBC-ODBC Bridge Server in to MultiProcess mode (as detailed above).

Applies To

• Products
  • Easysoft ODBC-ODBC Bridge
• Databases
  • Microsoft Access

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.

• 
• 
• 
•