RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()) er

Hi William,
Thank you so much for your instruction. I believe this is a good lead.
Speaking of trapping the error, I am not experienced at all.
will this a way to do it?
<%If Err.Number <> 0 Then
'do this again
set txn_info = conn.Execute(sQry)
<%End If%>
How can I check if the Connection pool was full or not. I always think maybe
we have many connection there and how can I check in SQL Server Profiler if
the operation made ti to the server or not.

if you can give me initial instruction or direct to the right resouces,
articles and anything might be helpful. I will be thrilled.

Sincerely


--
Betty


"c676228" wrote:

Hi all,

It seems that very frequently that we receive an error message on our
ecommerce site. See below. But when I click refresh button in the browser,
the page will be displayed correctly. I just don't know if it is database
connection problem or network problem or it is just memory corruption
problem. Don't have any clue where to start to correct the problem.

* COM Error #: -2147467259 (80004005)
* Category: Microsoft OLE DB Provider for ODBC Drivers
* File: ///receipt.asp
* Line, Column:49, -1
* Description: [Microsoft][ODBC SQL Server Driver][Shared
Memory]ConnectionWrite (send()).

line 48: sQry = "select * from tablename where order_id='" &
Request("order_id") & "'"
Line 49: set txn_info = conn.Execute(sQry)

This kind of error always occur at line conn.Execute(sQry) from different
programs. while conn is database connection and sQry is a very simple select
statement.
Does that mean we have database connection problem?
Its'quite a while, I have been searched the resolution. But never got any
idea how to avoid this annoying thing.
I guess our customer is quite upset with us.
Betty
.