Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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



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




  Return to Index