|
 |
asp_database_setup thread: ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Message #1 by "Max" <Twinsen24@h...> on Thu, 13 Dec 2001 09:25:34
|
|
Hi all,
This is the error Message i take in the face:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/update.asp, line 21
this is the full code:
----------------------------------
<%@ LANGUAGE = "VBScript" %>
<% response.buffer = true %>
<% session.LCID=&H040c %>
<%
turn = request.form("hidden")
set objconn = server.createobject("ADODB.Connection")
strpath = server.mappath("data.mdb")
objconn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
Source=" & strpath & ";" & "Jet OLEDB:Database Password=thepass;"
objconn.open
set objrs=server.createobject("adodb.recordset")
objrs.open "select * from menu", objconn, , adLockOptimistic, adCmdText
turny = turn
nb = 0
objrs.movefirst
do while turny > 0
nb = nb +1
caca = "menu" & nb & ""
damn = request.form(caca)
objrs("item") = damn
turny = turny - 1
loop
objrs.close
set objrs = nothing
'samething but for "content" table
set objrs2 = server.createobject("ADODB.Recordset")
objrs2.open "content" , objconn, , adLockOptimistic, adcmdtable
turny = turn
nb = 0
objrs2.movefirst
do while turny > 0
nb = nb +1
caca = "content" & nb & ""
damn = request.form(caca)
objrs("content") = damn
turny = turny - 1
loop
objrs2.close
set objrs2 = nothing
objconn.close
set objconn = nothing
response.write ("done")
%>
-------------------------------------------
So what's wrong ??
i look on http://www.adopenstatic.com/faq/800A0BB9.asp
i try their exemple
strSQL = "SELECT field1, field2 FROM table1"
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db1.mdb"
objRS.Open strSQL, strConnect, adOpenForwardOnly, adLockOptimistic,
adCmdText
but i take the same error message...
please save me.....
[MAX]
Message #2 by "Ken Schaefer" <ken@a...> on Thu, 13 Dec 2001 22:46:50 +1100
|
|
www.adopenstatic.com/faq/800a0bb9.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Max" <Twinsen24@h...>
Subject: [asp_database_setup] ADODB.Recordset (0x800A0BB9) Arguments are of
the wrong type, are out of acceptable range, or are in conflict with one
another.
: This is the error Message i take in the face:
:
: ADODB.Recordset (0x800A0BB9)
: Arguments are of the wrong type, are out of acceptable range, or are in
: conflict with one another.
: /update.asp, line 21
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
 |