ASP - user connections to SQL Server 7.0

Hi,

I have created a page that retrieves more than 500 entries from the database and displays 25 entries on the page at a time. I have 3 recordsets with 3 open connections to the database to retrieve the data. At the end of the page, I close all the 3 connections and set the recordsets to 'Nothing' (e.g. Set rsName = Nothing). However, when I browse the page, this is the error that I get:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The maximum simultaneous user count of 5 licenses for this 'Standard Edition' server has been exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version.

Does the license number has anything to do with the recordsets that I have in the code? I don't know how to solve the problem because in my understanding, the license number only has to do with the client connection to the SQL server.

I really hope that someone can help me with this problem as soon as possible. Thanks in advance.

maybe try closing them after they have obtained the recordset. and wait to set your record set to 'nothing'

I use a loop to display all the records retrieved from the database. So I should wait for the loop to finish before I can close the connections, shouldn't I? Can you please take a look at the file attached with this and give your comments? Thanks a lot.

Sounds more like a problem with your installation than an ASP or database error.

Even with 100 recordset objects you're still only using one connection.

How are you connecting out of interest? DSN or Hardcoded connection string?

Thanks for your reply. I'm using hardcoded connection string. I'm using a service of a web hosting company to host our database. They have no experience in using MS SQL 7 before and they are just doing a favor by hosting our application. Do you have any idea how I can help them solve this installation problem?

Thanks again.