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

What Do I Do If My Multi-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. Perform the following test:
    • Recreate the problem.
    • Run oplshut -s on a command line.
    • Observe the number of OpenLink database agent processes.
    • Compare the output of oplshut -s with a Unix ps -ef or Windows Task Manager.
    • Upgrade if oplshut -s or the Windows Task Manager shows more agent processes.
  6. Connect to Progress databases in sockets mode. A Progress shared memory library bug causes OpenLink's database agents to linger.
  7. 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.