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



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
.


Loading