Re: Is this server, client or jet engine problem?
From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 08/16/04
- Next message: Me: "Re: Is this server, client or jet engine problem?"
- Previous message: Bob Barrows [MVP]: "Re: how do you do "if record doesn't exist create otherwise update" in one SQL statement?"
- In reply to: Me: "Is this server, client or jet engine problem?"
- Next in thread: Me: "Re: Is this server, client or jet engine problem?"
- Reply: Me: "Re: Is this server, client or jet engine problem?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 16 Aug 2004 13:44:10 -0400
Me wrote:
> Hi,
>
> I'm getting an intermittent error on my site.
>
> The server is win2000 and the site is scripted with classic asp 3.0
> and vbscript.
>
> Everything has been fine for the last couple of years and I've made no
> changes.
>
> I've started getting this error
> *******************************************************
> I get the following error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
>
> [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
> *********************************************************
>
> I found this article at microsoft
> http://support.microsoft.com/?kbid=154869
>
> I contacted my host and they said that it was because too many users
> were trying to access the db at the same time.
That's simply the wrong diagnosis. It has nothing to do with the number of
users.
>
> I checked all my traffic log files and nothing has changed In fact
> the sites have had more hits in the past with no problems.
>
> This is affecting 2 domains hosted with the same host on the same
> server.
>
> Can anyone shed any light on this because I'm certain there's a
> problem with the host.
>
> Thanks
>
> Dan
Two suggestions:
Make sure you are explicitly closing and destroying your connections on each
page where they are used.
Try switching to the native Jet OLEDB provider rather than the obsolete ODBC
driver. (see www.able-consulting.com/ado_conn.htm for examples of connection
strings using this provider).
Bob Barrows
-- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
- Next message: Me: "Re: Is this server, client or jet engine problem?"
- Previous message: Bob Barrows [MVP]: "Re: how do you do "if record doesn't exist create otherwise update" in one SQL statement?"
- In reply to: Me: "Is this server, client or jet engine problem?"
- Next in thread: Me: "Re: Is this server, client or jet engine problem?"
- Reply: Me: "Re: Is this server, client or jet engine problem?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
