|
 |
access_asp thread: I NEED a third eye!!
Message #1 by "Wang, Julia" <Julia.Wang@R...> on Fri, 14 Dec 2001 13:48:22 -0600
|
|
Pls some one help me!!
ERROR--
ADODB.Recordset error '800a0bb9'
The application is using arguments that are of the wrong type, are out of
acceptable range, or are in conflict with one another.
CODE---
<%
Dim myRS
Set myRS = Server.CreateObject("ADODB.Recordset")
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
myRS.AddNew Array("FName", "LName", "Address", "City", "State", "Zip"), _
Array(Request.Form("FName"), Request.Form("LName"), _
Request.Form("Address"), Request.Form("Zip"))
myRS.Close
Set myRS = Nothing
myConn.Close
Set myConn = Nothing
%>
Thanks,
Julia
<*><*><*><*><*><*><*><*><*><*>
Message #2 by "Zee Computer Consulting" <zee@t...> on Fri, 14 Dec 2001 20:11:03 -0800
|
|
Julia,
Your first ARRAY() has six field names, but your second ARRAY() has only
four values. (The element counts must match.)
-- Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:48 AM
Subject: [access_asp] I NEED a third eye!!
> Pls some one help me!!
> ERROR--
> ADODB.Recordset error '800a0bb9'
> The application is using arguments that are of the wrong type, are out of
> acceptable range, or are in conflict with one another.
>
> CODE---
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew Array("FName", "LName", "Address", "City", "State", "Zip"), _
> Array(Request.Form("FName"), Request.Form("LName"), _
> Request.Form("Address"), Request.Form("Zip"))
> myRS.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
>
> Thanks,
> Julia
> <*><*><*><*><*><*><*><*><*><*>
$subst('Email.Unsub').
>
$subst('Email.Unsub').
Message #3 by "Ken Schaefer" <ken@a...> on Sun, 16 Dec 2001 12:35:21 +1100
|
|
www.adopenstatic.com/faq/800a0bb9.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Wang, Julia" <Julia.Wang@R...>
Subject: [access_asp] I NEED a third eye!!
: Pls some one help me!!
: ERROR--
: ADODB.Recordset error '800a0bb9'
: The application is using arguments that are of the wrong type, are out of
: acceptable range, or are in conflict with one another.
:
: CODE---
: <%
: Dim myRS
: Set myRS = Server.CreateObject("ADODB.Recordset")
: myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
: myRS.AddNew Array("FName", "LName", "Address", "City", "State", "Zip"), _
: Array(Request.Form("FName"), Request.Form("LName"), _
: Request.Form("Address"), Request.Form("Zip"))
: myRS.Close
: Set myRS = Nothing
: myConn.Close
: Set myConn = Nothing
: %>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #4 by "Wang, Julia" <Julia.Wang@R...> on Mon, 17 Dec 2001 08:41:21 -0600
|
|
Zee, thanks for the sharp eye! But still why my database is "read only"?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object
is read-only.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:11 PM
To: Access ASP
Subject: [access_asp] Re: I NEED a third eye!!
Julia,
Your first ARRAY() has six field names, but your second ARRAY() has only
four values. (The element counts must match.)
-- Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:48 AM
Subject: [access_asp] I NEED a third eye!!
> Pls some one help me!!
> ERROR--
> ADODB.Recordset error '800a0bb9'
> The application is using arguments that are of the wrong type, are out of
> acceptable range, or are in conflict with one another.
>
> CODE---
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew Array("FName", "LName", "Address", "City", "State", "Zip"), _
> Array(Request.Form("FName"), Request.Form("LName"), _
> Request.Form("Address"), Request.Form("Zip"))
> myRS.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
>
> Thanks,
> Julia
> <*><*><*><*><*><*><*><*><*><*>
$subst('Email.Unsub').
>
$subst('Email.Unsub').
|
|
|
View Cart
