SQL Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Error

Author

Topic

kopzen
Starting Member

34 Posts

Posted - 2008-10-21 : 10:30:43

Hi All

I get the following error in my Rightfax SQL Server, dont know where to start loolking for the problem:

Description:
SQL ERROR in <<Executing UPDATE Events SET DequeueTime = DATEADD(hour, -1, DequeueTime) WHERE (Parm1 = '8010') AND (Type = '3')>>
szSqlState = 08S01
pfNativeError = 0
szErrorMsg = [Microsoft][ODBC SQL Server Driver]Communication link failure
pcbErrorMsg = 61

ODBCRowNumber = -1
SSrvrLine = -1
SSrvrMsgState = 0
SSrvrSeverity = 0
SSrvrProcname =
SSrvrSrvname =
.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

hanbingl
Aged Yak Warrior

652 Posts

Posted - 2008-10-21 : 10:34:20

Network wide problem?

kopzen
Starting Member

34 Posts

Posted - 2008-10-21 : 10:38:13

Which part of the error message indicates Network problems;

And what type of network problems can cause this error?

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2008-10-21 : 10:38:44

Or, May be its using a connection which has already been dropped. You could try reconnecting again.

kopzen
Starting Member

34 Posts

Posted - 2008-10-21 : 10:42:49

Where do I check for current connections or connections with errors?

More Errors in the Agent:

Date 2008/06/26 07:17:23 PM
Log SQL Agent (Archive #1 - 2008/06/26 07:17:00 PM)

Message
[165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]

_-------------------------

ate 2008/06/26 06:34:42 PM
Log SQL Agent (Archive #2 - 2008/06/26 06:34:00 PM)

Message
[382] Logon to server 'ZAMDH111\RIGHTFAX' failed (SaveAllSchedules)

hanbingl
Aged Yak Warrior

652 Posts

Posted - 2008-10-21 : 10:49:10

Can you restart your SQL server? Reboot if that fails.

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2008-10-21 : 10:57:06