OPENROWSET leaves open ODBC connections

Posted on 2009-04-23
Last Modified: 2012-05-06

I'm using SQL 2000.  Our company uses OPENROWSET extensivelly to connect, via ODBC, to another database system (Advantage Database should it matter).

The problem is, over time open connections will build up to this database, because they are never being closed.  I'm talking tens of thousands!

Eventually, the Advantage database will lock up and not allow any more connections.  The only way to quickly clear these is to stop/start sql server/agent.  I'd rather not have to do this since it affects everyone in the company.

Is there another way to diagnose the open ODBC connections on my SQL Server computer, and if possible manually close/kill them when this issue occurs.

Question by:raterus
    LVL 31

    Expert Comment

    what SP your server has? SP4 may resolve your issue.
    LVL 33

    Author Comment

    Sorry, we are running SP4 already
    LVL 31

    Accepted Solution

    well in that case, I don't think so anybody will able to find direct automise solution for your problem as long as I know.
    LVL 33

    Author Comment

    I've resigned myself to the fact the problem is going to occur, I just want a better way to clear out these connections than to restart sql server.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now