Author |
Topic |
|
alextam
Starting Member
Hong Kong
42 Posts |
Posted - 04 August 2001 : 02:19:48
|
Hi, I would like to ask how i can prevent the server saying "Too many users connected..." error messages after rs.open? I have written "rs.close" already but the message continues.
Thank you. |
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 04 August 2001 : 03:20:52
|
Try SQL it can handle the users.
Test Site: http://www.eastpasco.com running on Huw's Code 3.308 SQL 2000 |
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 04 August 2001 : 05:44:12
|
how many users do you estimate are hitting the server at one time? Access should be able to handle quite a few.
<-- Eric -->
InsideWaco.com |
|
|
alextam
Starting Member
Hong Kong
42 Posts |
Posted - 04 August 2001 : 06:02:00
|
how many simutaneous users does access support? and how can i release the users connected to the server after completing rs.open?
by the way, how SQL handles the users?
Thank you very much!!
Thanks a lot! Regards. |
|
|
Spoon
Average Member
Ireland
507 Posts |
Posted - 04 August 2001 : 08:09:45
|
quote:
how many simutaneous users does access support? and how can i release the users connected to the server after completing rs.open?
by the way, how SQL handles the users?
Thank you very much!!
Thanks a lot! Regards.
If you are getting that message with an access db i advise you to change to SQL. ACCESS has problems handling alot of similtaneous requests. SQL works better and faster with alot of users. It is built for that kind of envirionment.
Regards - Spoon
Begineer? Need help installing the forums? - www.aslickpage.com/snitz_help.html
www.ASlickPage.com - Private Messaging |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 04 August 2001 : 12:25:59
|
You're not running on W2K Pro, NT4 Workstation, or PWS are you? They all have webserver connection limits hardcoded (10).
Access can handle moderately busy sites fine. The error may be unrelated to Access.
====== Doug G ====== |
|
|
alextam
Starting Member
Hong Kong
42 Posts |
Posted - 04 August 2001 : 21:41:05
|
I think the host server is NT4...so can't it be solved?
Thanks a lot! Regards. |
|
|
Cyber Paladin
New Member
55 Posts |
Posted - 05 August 2001 : 13:22:25
|
quote: You're not running on W2K Pro, NT4 Workstation, or PWS are you? They all have webserver connection limits hardcoded (10).
That's not entirely true, Win 2k Pro can actually have a 40 user connection limit. I just has to be set manually in the IIS properties. It does work, but of course it's against the user agreement... But I never got one of those anyways.
Remember... Amateurs built the Ark, but professionals built the Titanic. |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 05 August 2001 : 13:42:18
|
quote: That's not entirely true, Win 2k Pro can actually have a 40 user connection limit. I just has to be set manually in the IIS properties.
W2K Pro will let you change the settings in IIS, but it ignores your settings and restricts the usercount to 10 anyway.
alextam, I don't know if this is actually your problem or not. If you are hosting on a NT Server (not workstation), if the error is caused by IIS then the server admin has set a low limit for connected users. NT Server can be set to allow unlimited connections, and is set this way out of the box.
====== Doug G ====== |
|
|
SalmanKhana
Average Member
USA
961 Posts |
Posted - 13 August 2001 : 20:51:06
|
This error comes up because the DNS is not set probably. I had this error today alot. I called the hosting company and they set up a DNS for me and now it works fine.
They also asked me to check with Snitz developers as the 'active users' mod was displaying the same person more than once. They said that the objects keep piling if the database is not closed when a user leaves the site. Therefore the network shows busy.
I would like to know if snitz closes the database connection or not ?
|
|
|
|
Topic |
|