News Focus
News Focus
icon url

Mattu

01/22/04 7:48 PM

#34580 RE: Bob Zumbrunnen #34554

ASP bombed out at 7:43 PM EST. Again.

icon url

Dimension

01/22/04 8:43 PM

#34591 RE: Bob Zumbrunnen #34554

Bob,
your original message stated the error you were getting was "object doesn't exist".

in the code you posted, if typename returns anything other than "nothing", then it means the rs object was instantiated or set to a recordset: Dim rs as NEW recordset or set rs = my_conn.execute(someSQL)

perhaps you should search to see if there is a case where you are doing Dim rs as RecordSet, and then operating on the rs object without first assigning it a recordset?
Or similarly, a case where you are doing the same with connection?

what is perplexing is that you mentioned that this was working, it is just that when there is high traffic, you are getting the error. that leads me to believe you may be exceeding the maximum number of connections allowable by your SQL server configuration. Do you have an idea what is the number of connections at this time? are you using connection pooling or opening a new connection for every request?

some things to look at...

btw, i cannot post during the day anymore..your site is blocked from my work place because it is categorized as "chat". I can work around this by setting up a personal webserver at home and use that to load your pages. my question is, if i wanted to post..is there a template i can use? in other words, what are the minimum number of parameters to the URL i need to do a post? just curious...

icon url

AKvetch

01/22/04 9:17 PM

#34593 RE: Bob Zumbrunnen #34554

Bob, from Dimension's post in response to you, #msg-2194635:

that leads me to believe you may be exceeding the maximum number of connections allowable by your SQL server configuration

That is the continuing error message I get when the site fails.

FWIW,

AK