Microsoft OLE DB Provider for SQL Server: Connection failure

[Roadstone]

Hi All

Not sure if my query belong in this forum or another. I am a network engineer and a complete newbie when it comes to Microsoft SQL server, so go gently

I have a SQL database is running on a Microsoft SBS2003 server. There are 3 users running a client app on their workstations. In fact, a point worth noting is that there are only 3 workstations and one server on the network, connected via a 1GB switch. The problem is that the users of the database randomly drop their connections, resulting in the following error.

> CHistory.SaveHistory:
> -2147467259: Microsoft OLE DB Provider for SQL Server:
> Connection failure

> Last SQL Statement:
> Delete from History Where UserId = 751

Does anyone have any ideas on what might be causing this? I have trouble believing that it is a network latency issue (having performed traffic analysis), and the server does not show any performance related issues. That said, the guy that wrote the application is being less that helpful and keeps blaming the network, without giving us any useful feedback or advice on tweeking the database.

Does anyone have any tips / tricks that they can suggest that will help me get to the bottom of this? All feedback is most welcome.

Thanks

Rob

 

[genomon]

Knowing nothing about the offending application(s), here would be a good place to start your investigation:

http://www.sql-server-performance.com/oledb.asp

Good Luck!

I have great faith in fools; self-confidence my friends call it.
-Poe