Hello people,



This is the error i take directly in my face...



Provider (0x80040E21)

Multiple-step OLE DB operation generated errors. Check each OLE DB status 

value, if available. No work was done.









This is my ASP SCRIPT



<%@ LANGUAGE = "VBScript" %>

<% response.buffer = true %>

<% session.LCID=&H040c %>

<%



nb = request.form("hidden")



nb = int(nb/2)





'ouverture DB

Set cn = Server.CreateObject("ADODB.Connection")

strpath = server.mappath("data.mdb")



cn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & 

strpath & ";Persist Security Info=true"

cn.Properties("Jet OLEDB:Database Password") = "thepass"

cn.Mode = adModeReadWrite

cn.open 









'object qui prend les items du menu.....

strSQL = "SELECT * FROM menu"

set objsql = server.createobject("ADODB.Recordset")

objsql.open strsql, cn





'object qui prend les text et crée les table textes

strSQL2 = "SELECT * FROM content"

set objsql2 = server.createobject("ADODB.Recordset")

objsql2.open strsql2, cn









kultu = 0



do while nb > 0

kultu = kultu + 1



meno = request.form("menu"& kultu &"")







objsql("item") = meno

objsql.update

objsql.movenext





kultu = kultu + 1

cont = request.form("content"& kultu &"")



objsql2("content") = cont

objsql2.update

objsql2.movenext





nb = nb - 1

loop









objsql.close

set objsql = nothing

objsql2.close

set objsql2 = nothing

cn.close

set cn = nothing



response.write ("ok C fait [ici bientôt un menu]")



%>



So whats wrong ??



thank ans sorry for my poor english :-)

www.adopenstatic.com/faq/80040e21.asp



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Max" <Twinsen24@h...>

Subject: [asp_database_setup] Provider (0x80040E21) Multiple-step OLE DB

operation generated errors.





: Hello people,

:

: This is the error i take directly in my face...

:

: Provider (0x80040E21)

: Multiple-step OLE DB operation generated errors. Check each OLE DB status

: value, if available. No work was done.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~