Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

What Do I Do If My Single-Tier DSN Fails To Disconnect?

  1. Use your database native transaction monitor to see if OpenLink drivers are locked in pending transactions. OpenLink drivers cannot disconnect from a database while they are still engaged in transactions.
  2. Insure that your application does not enforce manual commits. Use of manual commit may encourage the behavior described above.
  3. Check the database native error logs for failures that may contribute to this problem.
  4. Create a client-side ODBC trace. Examine the trace to insure that the application sends the proper sequence of SQLFree()s and SQLDisconnect()s to the driver.
  5. Ensure OpenLink's Progress Single-Tier drivers establish sockets-based connections to Progress. A Progress shared memory library bug causes failures to disconnect.
  6. Contact OpenLink Product Support, if you use Progress 91C or 91D. OpenLink is working to resolve occurrences of lingering agents that are not associated with the shared memory bug.