Error disconnecting clients with ODBC Error

I keep getting an ODBC error (varies) I have SQL 7 on Windows 2000 server
with all the updated service packs and patches for the OS and SQL. I also
updated MDAC to 2.8 sp2. We use a third party software program that connect
s
to the SQL database to store all our data. Every so often we get
disconnected with an ODBC error and have to close the client then reconnect
to the server. The frequency is pretty sparatic sometimes it can occur 5
times and hour or as little as 1 time an hour. Attached is a copy of one of
the error we get if anyone has any ideas as to what could be causing this I
would greatly appreciate it.
ConnectionWrite (WrapperWrite()).
Last SQL String:
select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
MType='M' and MDateTime<=1124822591
Last ODBC Command:
Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
MStatus='U' and MType='M' and MDateTime<=1124822591'It's pretty hard to say from what's posted. This looks like
it's a HEAT database. If that's the case, Tracing their
sporadic errors with ODBC tracing will slow things down
quite a bit. You can but it's pretty bad on performance. Try
contacting the vendor, Front Range Solutions. That's
generally quicker.
-Sue
On Tue, 23 Aug 2005 12:33:04 -0700, "Anthony"
<Anthony@.discussions.microsoft.com> wrote:

>I keep getting an ODBC error (varies) I have SQL 7 on Windows 2000 server
>with all the updated service packs and patches for the OS and SQL. I also
>updated MDAC to 2.8 sp2. We use a third party software program that connec
ts
>to the SQL database to store all our data. Every so often we get
>disconnected with an ODBC error and have to close the client then reconnect
>to the server. The frequency is pretty sparatic sometimes it can occur 5
>times and hour or as little as 1 time an hour. Attached is a copy of one o
f
>the error we get if anyone has any ideas as to what could be causing this I
>would greatly appreciate it.
>ConnectionWrite (WrapperWrite()).
>Last SQL String:
>select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
>MType='M' and MDateTime<=1124822591
>Last ODBC Command:
>Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
>MStatus='U' and MType='M' and MDateTime<=1124822591'
>|||Anthony,
Try using another ODBC tool like WinSQL
(http://www.synametrics.com/winsql) and see if you get the same behavior.
How far is your database from your client? This could also be a network
issue.
Anthony wrote:
> I keep getting an ODBC error (varies) I have SQL 7 on Windows 2000 server
> with all the updated service packs and patches for the OS and SQL. I also
> updated MDAC to 2.8 sp2. We use a third party software program that conne
cts
> to the SQL database to store all our data. Every so often we get
> disconnected with an ODBC error and have to close the client then reconnec
t
> to the server. The frequency is pretty sparatic sometimes it can occur 5
> times and hour or as little as 1 time an hour. Attached is a copy of one
of
> the error we get if anyone has any ideas as to what could be causing this
I
> would greatly appreciate it.
> ConnectionWrite (WrapperWrite()).
> Last SQL String:
> select MRecordID from HEATMsg where MTo='Frank' and MStatus='U' and
> MType='M' and MDateTime<=1124822591
> Last ODBC Command:
> Function: SQLPrepare('select MRecordID from HEATMsg where MTo='Frank' and
> MStatus='U' and MType='M' and MDateTime<=1124822591'
>|||I will look into winsql, thanks. As far as the nework goes everything is in
the same physical location. I have checked network performance and nothing
indicates that it could be a performance problem.
"Dennis Black" wrote:

> Anthony,
> Try using another ODBC tool like WinSQL
> (http://www.synametrics.com/winsql) and see if you get the same behavior.
> How far is your database from your client? This could also be a network
> issue.
>
> Anthony wrote:
>