asp_database_setup thread: Re: Provider (0x80040E21) Multiple-step OLE DB operation generated errors.
Look out This Article From Microsoft...
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q269495
This article is self explanary.
Another quick tip is do not use Persist Security Info=true in connection
string while opening connection.
I hope this will help u!
bye,
Sandeep
29012002
> 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 :-)
View Cart
