SQL server Timeout problem?

[tb2007]

I have VB application with classes which have all functions for insert, update, select....data in SQL SERVER. I use SQL server only as back end to store tables and nothing else (no store procedures etc...).
In my client application I have one function where many concurrent users insert data in one table. That table has one field ntext. Very often there is a error:
"Microsoft OLE DB Provider for SQL Server Timeout expired 5"
Can somebody help me with this?
What does it mean 5 in the error message?

 

[eichen]

I have seen the same errmsg(without the following 5) from a lazy server that won't pick up the phone on the first or second ring.

If you are using ADO, before you open the connection you can set the ConnectionTimeout property to an integer value in seconds: mycxn.ConnectionTimeout = 10
Maybe that will help the multiple-user bottleneck.