ODBC SQL Server Driver][Shared Memory] ERROR

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

SQL Server 2000 Forums

Transact-SQL (2000)

ODBC SQL Server Driver][Shared Memory] ERROR

Author

Topic

kaff
Starting Member

11 Posts

Posted - 2006-01-17 : 16:16:42

Hi,

I was running a stored procedure on production database and I got this Nasty Error Message, I was running it on LOCAL Server using Query Analyzer.. it Approxly took 5 hours and after that it generates that error. Could you please help me, why this happened? what does that means? Any help is highly appriciated.

Here is my code Routines...

BEGIN TRAN LogResultTrans
-- Log the Activity Event
COMMIT TRAN LogResultTrans

BEGIN TRAN SchedTask

SET @ErrNum = 0
--Process the code

IF @@ERROR <> 0 SET @ErrNum = @@ERROR

IF @ErrNum <> 0
BEGIN
ROLLBACK TRAN SchedTask
END
ELSE
BEGIN
--Update the Activity
COMMIT TRAN SchedTask
END

EXEC another stored procedure
EXEC another stored procedure
GO

:::::ERROR MESSAGE::::

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

Kaff

TimS
Posting Yak Master

198 Posts

Posted - 2006-01-17 : 16:53:53

I never figured out the cause, I just started using TCP/IP for stuff and the error went away for me.

I think, the computer I was using as the client had a WINS issue; and later found out the server I was connecting to had a MSDTC issue.

Tim S

kaff
Starting Member

11 Posts

Posted - 2006-01-17 : 17:02:58

Thanks TimS.

I connected to my Server using "Remote Desktop Connection" with Administrative Rights.

Is that what is causing the Issues?

Thanks is Advance

Kaff

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-17 : 17:15:31

see this
http://sqlteam.com/forums/topic.asp?TOPIC_ID=51866

kaff
Starting Member

11 Posts

Posted - 2006-01-17 : 17:44:28

Thanks all.
I checked the Eventlog.. there was Network outage which caused that issue.
Sorry I should been checked that earlier.

Thanks again to all good peoples.

Kaff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources