Multiple-step OLE DB operation generated errors
Hej eksperter,i et program, som plejer at virke, får jeg pludselig denne meddelelse:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/test/datcon.asp, line 114
Hvorfor? Programmet er ved at lægge data i en access-base, linie 114 er "bib.AddNew":
SET nyt = Server.CreateObject("ADODB.Connection")
nyt.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("bookstore1.mdb")
set bib = server.createobject("ADODB.Recordset")
sqlny="select * from table1 where client<>''"
bib.open sqlny, nyt, adopenstatic, adlockoptimistic
for b=1 to a
bib.AddNew
bib("engagement")=engagement(b)
bib("client")=client(b)
bib("partner")=partner(b)
bib("asspartner")=asspartner(b)
bib("manager")=manager(b)
bib("enddate")=enddate(b)
bib.Update
next
bib.close
Mvh Carsten
