• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1025
  • Last Modified:

OPENROWSET leaves open ODBC connections

Hello,

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.

Thanks!
0
raterus
Asked:
raterus
  • 2
  • 2
1 Solution
 
RiteshShahCommented:
what SP your server has? SP4 may resolve your issue.
0
 
raterusAuthor Commented:
Sorry, we are running SP4 already
0
 
RiteshShahCommented:
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.
0
 
raterusAuthor Commented:
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now