[Microsoft][ODBC SQL Server Driver]Timeout expired

Hi,
Our web applications are using COM objects to call sps in
SQL server. We are getting a lot of timeout errors. If
you know why this happens and any fixes pls let me know.
The error looks like following:
[Microsoft][ODBC SQL Server Driver]Timeout expiredhi
I also face to that prob.At last i found the solution for the "timeout
expired" problem. what we
have to do is, we have to edit two windows files calld
,"c:\winnt\system32\drives\ect\hosts.txt"
and "c:\winnt\system32\drives\ect\Lhosts.txt"
we should enter sql server IP and name like this
169.192.2.100 sqlserverName
in both files
Thanks,
indika
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!