I m doing some calculation which requires connecting to the database.
In some small cases it need 4 or 5 connections to the database. but in some other cases it requires about 500 connections
(connections are 1 by 1 & i open each one and make sure to close it)
in small cases it works perfectly
but when there are too many connections it just doesn t do anythng.
I added an ajax update progress to see if something is happening or not it s on for 1 minute and then it goes away and nothing happens?
what does that mean?
does it timeout? and if it does where is the timeout exception?
how can i fix this?
Asp.net ==> C# as background language
IIS server
currently i m using a test database which is a microsoft access file- but after i publish it it ll use MS SQL server database

The reason that i have so many connections is that i m generating a tree view which can have n levels and i get the info from the data from my database the tree is something like and it grows depends on the users that join the website
1
2
6
12
13
7
8
3
9
10
11
4
5

something like that so for each user in the whole tree i need a connection to get all the sub users for that user
so if i have 500 ppl in the tree i need 500 connections

http://pinastro.wordpress.com/2008/06/15/ajax-eludes-harry-potter-xml-bludgers-cause-serious-injury/

Ajax are a great club I know- but following the Dutch display thus far- Van Basten could have walked into almost any job and dictated his own terms!!

Heres my shot and yes Scotland is a different country not Wales. =)

England: Manchester United
Scotland: Rangers
Ireland: Cork City
France: Lyon
Portugal: FC Porto
Spain: Real Madrid
Italy: AC Milan
Sweden: FC Malmo
Norway: Rosenborg
Germany: Bayern Munich
Greece: AEK Athens
Serbia: Red Star Belgrade
Switzerland: FC Basel
Belgium: Anderlecht
Netherlands: Ajax
Turkey: Galatasray
Poland: Wisla Krakow

Give or take a few countries those are my best shots correct me if you may.

1.Wrestling became an Olympic sport in 708 B.C. and was also the final and decisive event of what competition?
2.Who was the youngest U.S. wrestler to win a world title?
3.Which U.S. President often talked about his wrestling days as a young man in Illinois?
4.In The Illiad- Homer recounts a famous wrestling match between Ajax and what other mythological figure?

Everyone gets a Thumbs Up from me Regardless of Answer.