SQL SERVER 2000 Access Denied HELP!

[EmperorIQ]

When running a asp page I get this error message.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

What is funny is that half of the page runs (the database is being accessed) then it just stops, and spits out this message. When this error occurs web pages accessing this database will be down as well. The page gathers over 100 rows and then runs queries on each of the rows, which will cause a lot of load on the server. Also it usually takes about 30 seconds to load. Has anyone ever had a problem like this? I'm really confused and probably am not capable to provide enough information. Any help is appreciated.

thank you,

 

[WannaFly]

are you using the same connectionstring? same database? are you SURE you dont have a typo in the name?

 

[EmperorIQ]

from what it looks like there is too much load on the server, which seems impossible. Some records do show up and display, but at a certain point everything is just denied and the server goes down for a good 2 minutes. Any type of access to the database from other asp pages will not go through.

 

[HeroOfPellinor]

No clue. But, why are you running queries on each row rather than doing a join?

 

[EmperorIQ]

I'm actually modifying the existing code. It sort of works like this.

Someone rents an item. use a query to get all items rented along with the time it was due and the time it was turned in.

from there I run a query on each of those rows to check that the rented item was returned before the closing time for that day.

I guess I could have another query and do a join, gotta get the ok from the boss though.

Thanks for your help.