SQL Connection issues

[Deam]

:-0
Can anybody help me with this
Due to some reasons my sql server (7.0) is opening up like 6 connections in a minute for the same user.So eventually all the connections are used up. This happens even though there are 4 or 5 users logged in.
Where can i check for this? Are there any configuration properties which control this?
any help is appreciated...

 

[tlbroadbent]

The issue isn't likely with SQL Server. Client applications open connections with the server rather than the server opening connections to the client. So you need to begin with the client software.

Need to know client application, client software version, type of connection (ODBC, ADO) and connection string before I can provide much help on this one. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[Deam]

This is a web based application using ASP's which is using sql server 7.o as its back end. There is an ADO connection. The same application is running fine on another workstation.