Error: 40002 - 01S03: [Microsoft][ODBC SQL Server Driver]No rows updated or deleted 
Author Message
 Error: 40002 - 01S03: [Microsoft][ODBC SQL Server Driver]No rows updated or deleted

Good morning,

Please help with a frustrating problem.   I could have sworn this used to
work but now I can't
get an update to work with Remote Data Objects using VB 4.0 Enterprise
Edition.

I get the following error (from debut window)

?err
40002
?error(err)
01S03: [Microsoft][ODBC SQL Server Driver]No rows updated or deleted

The code is simplistic: (I've broken up the lines in this message for
reading)

SQL = "select workstation, customer_no, img_store_date, img_arch_stat,
img_arch_date
        from images where img_arch_stat = 'A' and workstation = '0171'"
localDb.QueryTimeout = 2400
Set LocalRs = localDb.OpenResultset(SQL, rdOpenKeyset, rdConcurRowver)

While Not LocalRs.EOF

BeginTrans
        LocalRs.Edit
                LocalRs!img_arch_stat = "Q"
                        LocalRs!img_arch_date = Now()
            LocalRs.Update

CommitTrans

ProgressBar.Value = ProgressBar.Value + 1
lblCurrent.Caption = ProgressBar.Value

frmUpdateCIS.Refresh
DoEvents

LocalRs.MoveNext
Wend



Fri, 29 Oct 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Error : 40002 - 01S03: [Microsoft][ODBC SQL Server Driver]No rows updated or deleted

2. 01S03 [Microsoft][ODBC Library] No rows updated or deleted

3. Run-Time Error 40002 (Internal Driver ODBC Error)...

4. VB Sql Server Via ADO Problem: [Microsoft][ODBC Sql Server Driver]

5. Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,

6. Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,

7. Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,

8. ERROR 40002 to MS SQL 6.5 VIA ODBC

9. S1T00[Microsoft][ODBC SQL SERVER DRIVER] TIMEOUT EXPIRED ?????????

10. S1T00[Microsoft][ODBC SQL SERVER DRIVER] TIMEOUT EXPIRED ????

11. 0 [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt

12. 01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right truncation

 

 
Powered by phpBB® Forum Software