Command Timeout using DatabaseSpecific.DataAccessAdapter

Posts   
 
    
DrM
User
Posts: 49
Joined: 09-Feb-2004
# Posted on: 02-Feb-2005 16:03:56   

How do you set the command timeout when using the DatabaseSpecific.DataAccessAdapter.

I can' t find a time out option for the command and I leep getting a time out error.

Regards DrM

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 02-Feb-2005 17:13:17   

DataAccessAdapter adapter = new DataAccessAdapter(); adapter.CommandTimeOut = 60; // 60 seconds // use adapter further with your code here.

Be aware that a timeout often signals a deadlock somewhere if you're using sqlserver.

Timeouts aren't supported on Firebird.

Frans Bouma | Lead developer LLBLGen Pro