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 |
|
lily
Starting Member
6 Posts |
 Posted - 2002-01-28 : 21:07:28
|
| On the NT network there are 70 users to access VB program which is on the file server and connect to SQL database server.VB program use ADO connecting with SQL server.VB program have "timeout expire" error message frequencenly.But I can ping the server IP address. When the "timeout expire" error come out,all the NT workstation connect to network very slow.Even only open folder on the file server. But the NT server is OK!what cause the problem: network traffic? SQL server setup? VB application? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-28 : 22:41:54
|
| HiGenerally the cause of timeouts is inefficient coding. Have a look at the queries you are running, are they optimised ? If you are using lots of cursors or something horrible like that it will slow down. When you use VB to open a recordet, are you returning more rows than you need ? Are you cleaning up your database connections ?Some thoughtsDamian |
 |
|
|
|
|
|
Error:Timeout expire