Communication link failure

[shaminda]

Does anyone know the cause of this error? I got this error in a visual basic program. The program was running fine and suddenly the program got stuck. I had to restart my computer to recover the program. I contacted my DBA and he said nothing was wrong on Server side.

This is the message:
-2147467259, [Microsoft][ODBC SQL Server Driver]Communication link failure

[Johnny101]

it's been my experience that this error means the network connection between the client and server was lost. basically your LAN went down - the server kept on running, but your app couldn't use the network to talk to it.

John

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org

[sivanandam]

Hi

Just I want to raise this question.
O.K I had some views on this.
This is mainly due to the netwotk problem .
Due to heavy trafic.In your question U didn't mention about how u use this.
Remote access. Are using Lan,Or single system
If its lan check your Lan connection properly
and try to establish the connection in the
error.

You can stimulate the same error by removing the network card from sqlserver .(Go for debug
mode)
Bye
Sivanandam S




What We Now is God's Gift to US
What we Become os Our's gift to God.

[shahshaila]

I am having the same problem. It is single system. Database and application are on the same machine. I am using MSDE engine and VB6 as frontend. My connection string looks like below.
"Provider=MSDASQL;Driver={SQL Server};Server=" & mSvrName & ";DATABASE=cnsClient;uid=uid;pwd=pwd"

Please help. This problem occurs only sometimes.