RE: FN-FORUM: ASP / Access problem

date posted 21st January 2004 15:17

That's 20 or more simlutaneous users.

You should ensure that the connection is terminated ASAP as it can be -
best way is to use disconnected recordsets.

And if in your DB access code you should put in some error handling that
if you get specific errors like this that are down to time-outs etc.,
you can get it to re-request the data once it's timed out - up to
whatever re-request limit you decide to programmatically enforce.

Access is your enemy...
Migrate to SQL Server (MSDE)=20


Andy
IWD2 LLP
[EMAIL REMOVED]
=20
-----Original Message-----
From: Dan Cook [EMAIL REMOVED]
Sent: 21 January 2004 15:57
To: Andy Macnaughton-Jones
Subject: FN-FORUM: ASP / Access problem


Hi everyone,

I've had an error message come up on one of my forums (listed here:
http://www.bsooy.com/dynamiclink/DC_solutions.asp?RECORD_KEY[DC]=3DID&ID%=
5
BDC%
5D=3D10)

Apparently, in laymans terms, it says my ASP forum will 'pack up' every
time 20 or more users try and log in at the same time! This is a huge
pain in the arse and I was wondering whether anyone has any ideas on
workarounds etc. I really don't wont to rebuild the forum from scratch.
Is there any way that I can use something else instead of the .mdb
database that requires very little work? text files or asp files etc ?

many thanks

Dan


--
** Get all the Freelance Work you Can Handle * The Web Design Business
Kit will show you proven tactics and strategies for marketing your
business, winning bids, managing projects and pricing your work. Free
Shipping Worldwide.
Read more & get free chapters at:
http://www.sitepoint.com/launch/b7c91e/3/4

To advertise here: http://www.freelancers.net/advertising.html