RE: FN-FORUM: ASP / Access problem

date posted 21st January 2004 16:05

Hi Dan

Reading that error page (finally got the URL to work) I think you need
to "reference page 343 in the Adobe GoLive 5 Manual" ;) Being serious
http://www.bsooy.com/dynamiclink/sql_tutorial.htm walks you through
moving the application to a SQL Server backend. However as other people
have already pointed out it sounds like the application probably hasn't
been particuarly well written (out of interest just how much traffic do
you get to the forum) so if you're feeling brave you might want to
consider wading into it. Or alternativly invest in something like
Snitz.

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