Hello to all
I am using an application which is in vb6.0 and database in MSSQL server 2k.
I am using connection string through ADO.
Some times I receive message Timeout expired when I retreive data from table e.g
Vendor (Select * from Vendor) through vb6.0 application .
When I retreive data from table through SQL Server enterprise manager It
also generate Timeout expired message.
For the time being to get rid this error I restart database server or
Kill the ProcessID through MSSQL Server enterprise manager
Management->Current Activity->Process Info.
Please advice why this error come and how I can get rid this error through proper channel.
Note : Vendor table is not more than 500 rows.
Thanx in advance
I am using an application which is in vb6.0 and database in MSSQL server 2k.
I am using connection string through ADO.
Some times I receive message Timeout expired when I retreive data from table e.g
Vendor (Select * from Vendor) through vb6.0 application .
When I retreive data from table through SQL Server enterprise manager It
also generate Timeout expired message.
For the time being to get rid this error I restart database server or
Kill the ProcessID through MSSQL Server enterprise manager
Management->Current Activity->Process Info.
Please advice why this error come and how I can get rid this error through proper channel.
Note : Vendor table is not more than 500 rows.
Thanx in advance
Comment