Run-Time Error '-2147467259(80004005) SQL Server does not exist or access denied

[charmedcharmer]

Guys I need some help. I have this server application done in VB which constantly processes records in and out of the database. Queries are being executed every number of seconds.

What happens is that every now and then I get a runtime error saying: [DBNETLIB]{ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I have a hunch that the server is being disconnected from the network and my network administrator doesn't believe me. Is there a way for me to prove this?

I know I could trap the error so that my application doesn't get this error. But its not the issue here. The issue here is that servers should not be disconnecting from the network.

[brucevde]

Queries are being executed every number of seconds.

Is there anything in the SQL Server Log file or the server's Event viewer?
Use SQL Profiler to help diagnose the problem.

ADO and the OLE Providers do a lot of things "behind the scenes". For example, if a connection is considered busy the provider might simply open and use another connection. Your code may be spawning these extra connections. These KB articles explain the problem.

http://support.microsoft.com/kb/907264
http://support.microsoft.com/kb/194979

[charmedcharmer]

Sorry for the late reply. Unfortunately I don't have access to other SQL applications like the Profiler. Only Query Analyzer was given to me.

Thanks for the help. I'll be reading the article in your link.