Timeout expired while retrieving data from table

[mabubakarpk]

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

[debasisdas]

This problem is becasue it is taking too long to establish the connection from VB to SQLServer.

You need to set the Connection.ConnectionTimeout property in VB6.0

[mabubakarpk]

This problem is becasue it is taking too long to establish the connection from VB to SQLServer.

You need to set the Connection.ConnectionTimeout property in VB6.0

Thanx dear for reply

I have also set connection.connectionTimeout property but why same error come when I reterieve data from MSSQL Server enterprise talble return all rows. while table contains only 500 rows

[debasisdas]

It does not matter what is the number records that you are trying to retrive. It depends what is the time taken to establish the connection. It depends on alot of factors like network speed and also hardware.

[davef]

It does not matter what is the number records that you are trying to retrive. It depends what is the time taken to establish the connection. It depends on alot of factors like network speed and also hardware.

Since you seem to get a timeout error even via the console, check out whether you have any locks on the table.