Timeout Expired

[btgroup]

Hi,

I have an SQL command that I am executing through some VB code. The code is as follows:

Dim oss_conn as ADODB.Connection
Dim oss_rs as ADODB.Recordset
Dim sql_statement as String
oss_conn.Open "...typical connection string..."
sql_statement = "UPDATE sales SET override = 1"
Set oss_rs = oss_conn.Execute(sql_statement)

I am able to manually run the sql statement, but my VB code gives me a Timeout expired error. When I switch the sql statement to update a different table, it runs perfectly. I have tried to extend the commandtimeout property and it didn't help. The table is very small.

Any ideas? Maybe it is a permissions issue on the table? I am using the same user when I connect through the VB code as when I run the statement manually.

Thanks in advance for any help.

 

[TomKane]

You should check the current activity screen to see if there is a process that is blocking your query

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_6ofn.asp

 

[btgroup]

Thank you. There was indeed a process blocking the query. Once I closed the connection and re-opened it, everything ran as expected.