Boards
News
Market Data
Markets
Discover
Discover
AI Subscribe Login/Register account icon
S&P 500
7,091.38
(
-0.25%
)
US TECH 100
25,851.60
(
-0.08%
)
Dow Jones
49,355.37
(
-0.19%
)
Brent Oil
94.36
(
4.06%
)
Bitcoin
75,702.32
(
-0.25%
)
News Focus
News Focus
Post# of 222455
Next 10
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Dimension

Send PM Follow Ignore
Followers 39
Posts 10609
Boards Moderated 1
Alias Born 07/08/2003

Dimension

Member Level

Re: Bob Zumbrunnen post# 34554

Thursday, 01/22/2004 8:43:24 PM

Thursday, January 22, 2004 8:43:24 PM

Post# of 222455
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...

Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Discover What Traders Are Watching

Explore small cap ideas before they hit the headlines.

Join Today