Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connections

Status
Not open for further replies.

DirtyB

Programmer
Mar 13, 2001
159
US
We are having some licensing issues with a SQL Server that is the backend of some asp software we just purchased. We have a 15 connection license. What i'm noticing, is that no matter how many users are logged into the asp software, it only shows that there is one connection to the database. The only way it seems that I can max out the connections is to open up several windows in query analyzer. Is it possible that the asp software has pooled it's connections all into one? We are worried that when this thing goes live, we'll run out of licenses in ten minutes. Thanks for any input.
 

Typically, ASP uses one connection for all clients. That occurs because users connect to the web server and the web server connects to SQL Server. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot
 
As far as I know, ASP.DLL (the DLL responsable for interpreting your ASP code) is communicating through pipes with SQL server. I suppose it needs only one connection for the following reasons:

1. the scripts must be executed in the order of receive and not at the same time, otherwise how could the ASP keep track of global variables changes.
2. the same thing applies to ASP-SQL link, think of what would happen if many connections were working on the some table at the same time. The results would then be unpredictable for the ASP.

This is my oppinion, not a written fact

Hope this helps, s-)
Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...
 
MS requires you to have a Client Access License for each device that accesses a SQL Server database. The newly announced "Processor License" should be used to license most Internet or Extranet connected SQL Servers. The CPU License gives you unlimited client access. Note that you will need a "SS Processor License" for each CPU on your SQL Server platform.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top