I am using an SQL update statement in VB 6.0 to update a SQL Server 7.0
table and I keep getting a timeout error.  There are about 600,000 records
in the table and I am using a lookup with two fields which will retrieve the
one and only record that needs to be updated.

Code:

ls_sql_cmd = "update verify_data set input_value = '" & tresult & "' where
verifyid = " & tverifyid & " and fieldid = 1"
cn.execute (ls_sql_cmd)

Does anyone have any ideas why I keep recieving a timeout error?

Please help, thanks

Brent Burkart

I can think of a couple, both related to the size of the tempdb in SQL
server and one related to what you are attempting.  First of all I don't see
the tablename in your statement.  Is there a reason for this?

Have you tried running a query in query analyser for the select part of the
statment - something like the following:

select * from x where
 verifyid =   tverifyid and fieldid = 1

If this statement executes quickly there, then the problem has to do with
your cursor type or other connection attributes.

Hope that helps....

Philip Meeks
ETVTechnologies

update verify_data set input_value = 'MyValue' where verifyid = 2 and
fieldid = 1

Now cut and paste it into Query Analyzer (SQL 7's equivalent to ISQL/w)
How long does it take compared to the VB code's timeout property?

Within Query Analyzer is a menu option to enable some performance stats /
execution plan. Run the query again and see what it suggests in terms of
optimization.

Just my 2€'s worth