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.
| Author |
Topic |
|
sppatel777
Starting Member
1 Post |
 Posted - 2007-02-24 : 06:07:04
|
| Dear Friends,I ve develope on VB application. and I ve one server with 2000 Server OS.and with SQL SERVER 2000 installed on that. I am also having 10 clients with Win XP OS and have to run VB application from clients to store data in server.I can fetch the record from server and also store the records in the server's Database from all the clients. But unfortunately sometime i got the error 'Timeout Expired', and some time my application runs smoothly. I am confused on that strange errorIs it Network Issue??If anyone have the solution Plz help me........Thank You...... |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-02-25 : 08:56:06
|
| How about increasing the Timeout preiod of the Connection Object?Chiraghttp://chirikworld.blogspot.com/ |
 |
|
|
subodh.bhave
Starting Member
1 Post |
Posted - 2007-02-26 : 05:31:51
|
| There can be lot of reasons for thisCheck out your Server Network Library i.e whether it is TCP-IP library or Named pipesAs Chirag has mentined, check out for Connection timeout for connection object. If you are using select qry dirctly then try using command object instead of executing direct querySubo |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-26 : 06:07:19
|
| Also instead of avoiding errors like "timeout expired" by increasing timeout property, take a proactive approach and try to tune the query/SP so that timeout situations will be less frequent. Of course, it also depends upon your network settings and load on the server.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
Timeout Error with VB6.0- SQL SERVER 2000