1

When I run the query through VB6, I am getting error as "Time Out Expired"

For ADO Connection, I used addConn.CommandTimeout = 1000

For RDO Connection, How can i used CommandTimeout..?

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
Gopal
  • 11,712
  • 52
  • 154
  • 229
  • You don't need to say "Need VB6 Code Help" every time, that is implied in the tags. – Deanna Nov 23 '11 at 09:01
  • How long is it taking before you get the time out expired? There might be a command timeout default on your connection which is causing this. – Shane Wealti Nov 23 '11 at 14:11

1 Answers1

1

The equivalent in RDO is the QueryTimeout

It can be set (in seconds) as below:

rdoConnection.QueryTimeout = 60
rdoPreparedStatement.QueryTimeout = 60
rdoQuery.QueryTimeout = 60
Stephen Turner
  • 7,125
  • 4
  • 51
  • 68