[RESOLVED] Time out Expired

[vplag]

Hello gurus,

i have an application that is accessing a table with 80.000.000++ records that have indexing. when i'm trying to make any action with this table, select, update... i'm taking this error. how i can make the time expire condition bigger?

Thanks

VPlag

[Shuja Ali]

Increase the ConnectionTimeout property of the connection object to max before running the query.

[vplag]

I'm still recieving the same error

my code during the load of the project is

    Set VPConnection = New ADODB.Connection
    VPConnection.ConnectionTimeout = 480
    VPConnection.Open (CSTR_CONNECTION)

Public Const CSTR_CONNECTION = "Provider=SQLOLEDB.1;Password=testpwd;Persist Security Info=True;User ID=vp;Initial Catalog=Phones8History;Data Source=kronos"

[vplag]

ok!

i've solved it.
the problem was to the connection time out of the command object that i was doing updatings....

Thanks!

[Shuja Ali]

I was going to post that now. But before I could post I saw that you had done it yourself.

[Madhi]

Also refer these
http://vyaskn.tripod.com/watch_your_timeouts.htm
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm