RE: FN-FORUM: ASP / Access problem

date posted 21st January 2004 15:58

Hi Dan

It really depends on your forum software. Some forum software (for
example Snitz) will support a wide range of databases, and all you need
do is change a setting somewhere. Other software might need a complete
re-write.

Norman



-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Dan
Cook
Sent: 21 January 2004 16:18
To: FN-FORUM / [EMAIL REMOVED]
Subject: Re: FN-FORUM: ASP / Access problem



Cheers for the replies,

As unlikely as 20 concurrent connections sounds, it's happened twice
this week! It's my stupid fault for using Access but I'm not really a
techie, so I don't know much about the alternatives (correction....I
know bugger all). Is it fairly straightforward to replace the Access
file with something else - don't suppose anyone knows of any decent
tutes?



----- Original Message -----
From: "Norman Beresford" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Wednesday, January 21, 2004 4:11 PM
Subject: RE: FN-FORUM: ASP / Access problem


>
> Hi Dan
>
> You'll probably find that's 20 concurrent connections. Which is
> probably a bit high (IIRC Access tends to throw a wobbly at around
> 10), but to be honest it's very unlikely you'll have 20 concurrent
> connections (and if you do you really shouldn't be driving your site
> with Access). If it's 20 connections full stop then it's either a
> hardcoded limit which means hacking around with the existing code to
> get round it, or move to a different forum system.
>
> No doubt someone will tell you to use mySQL instead of proposing a
> solution/telling you why it's not a problem, just ignore them.
>
> hth
>
> Norman
>
> Ps, did that link actually work for anyone?
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Dan
> Cook
> Sent: 21 January 2004 15:57
> To: FN-FORUM / [EMAIL REMOVED]
> 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]=ID&ID
> %5
> BDC%
> 5D=10)
>
> 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
>
>
> --
> ** 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
>
>
--
** 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