I'm new to the VB/SQL Server world and am having the following problem:

I get timeouts when executing either UPDATEs or DELETEs. INSERTs work fine.

Here's the code ("PROJ_DB" is the connection):

g_sSQL = "UPDATE tblRefI SET strType='A',sngRefI=1.23 WHERE strType='A';"
PROJ_DB.Execute g_sSQL, , adCmdText

and

g_sSQL = "DELETE FROM tblRefI WHERE strType='X';"
PROJ_DB.Execute g_sSQL, , adCmdText

and

g_sSQL = "INSERT INTO tblRefI (strType,sngRefI) VALUES('A',123);"
PROJ_DB.Execute g_sSQL, , adCmdText

If anyone can help, I'd really appreciate it. Thanks.