|
 |
access_asp thread: Why I cannot update RS?
Message #1 by "Wang, Julia" <Julia.Wang@R...> on Fri, 14 Dec 2001 13:33:42 -0600
|
|
Some one pls help me!
ERROR---
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object
is read-only.
CODE----
<%
Dim myRS
Set myRS = Server.CreateObject("ADODB.Recordset")
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
myRS.AddNew
myRS("FName") = Request.Form("FName")
myRS("LName") = Request.Form("LName")
myRS("Address") = Request.Form("Address")
myRS("city") = Request.Form("City")
myRS("State") = Request.Form("State")
myRS("Zip") = Request.Form("Zip")
myRS.Update
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:24:24 -0800
|
|
Julia,
Possible cause: Your recordset-open command needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") = Request.Form("FName")
> myRS("LName") = Request.Form("LName")
> myRS("Address") = Request.Form("Address")
> myRS("city") = Request.Form("City")
> myRS("State") = Request.Form("State")
> myRS("Zip") = Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
$subst('Email.Unsub').
Message #3 by "Wang, Julia" <Julia.Wang@R...> on Mon, 17 Dec 2001 08:28:57 -0600
|
|
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") = Request.Form("FName")
> myRS("LName") = Request.Form("LName")
> myRS("Address") = Request.Form("Address")
> myRS("city") = Request.Form("City")
> myRS("State") = Request.Form("State")
> myRS("Zip") = Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
$subst('Email.Unsub').
Message #4 by "Enzo Zaragoza" <enzaux@g...> on Mon, 17 Dec 2001 22:50:51 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00FE_01C1874D.46D0DFD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
check if your syntax is correct on opening the recordset and also the
variables you used in your statement they might have been scrambled out
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what
you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth
parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your
pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS =3D Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") =3D Request.Form("FName")
> myRS("LName") =3D Request.Form("LName")
> myRS("Address") =3D Request.Form("Address")
> myRS("city") =3D Request.Form("City")
> myRS("State") =3D Request.Form("State")
> myRS("Zip") =3D Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS =3D Nothing
> myConn.Close
> Set myConn =3D Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #5 by "Enzo Zaragoza" <enzaux@g...> on Mon, 17 Dec 2001 22:52:37 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0105_01C1874D.86072010
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Oh may be adOpenKeyset hs the problem because Ken Schaefer said that
adOpenKeyset does not work on all platforms I think try searching the
archive about "why do i get -1 in recordcount" he has something said
there
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what
you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth
parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your
pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS =3D Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") =3D Request.Form("FName")
> myRS("LName") =3D Request.Form("LName")
> myRS("Address") =3D Request.Form("Address")
> myRS("city") =3D Request.Form("City")
> myRS("State") =3D Request.Form("State")
> myRS("Zip") =3D Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS =3D Nothing
> myConn.Close
> Set myConn =3D Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #6 by "Wang, Julia" <Julia.Wang@R...> on Mon, 17 Dec 2001 08:45:26 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C18709.76E8ACA0
Content-Type: text/plain;
charset="iso-8859-1"
Thanks a lot, Enzo. Could you instruct me how to get to the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer said that
adOpenKeyset does not work on all platforms I think try searching the
archive about "why do i get -1 in recordcount" he has something said there
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" < Julia.Wang@R...
<mailto:Julia.Wang@R...> >
To: "Access ASP" < access_asp@p... <mailto:access_asp@p...>
>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") = Request.Form("FName")
> myRS("LName") = Request.Form("LName")
> myRS("Address") = Request.Form("Address")
> myRS("city") = Request.Form("City")
> myRS("State") = Request.Form("State")
> myRS("Zip") = Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
$subst('Email.Unsub')
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
Message #7 by "Enzo Zaragoza" <enzaux@g...> on Mon, 17 Dec 2001 23:09:23 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0157_01C1874F.DDC00680
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
just go to p2p.wrox.com then from the upper left corner you ll find a
text box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use
adOPenKeySet? by the way do you really knows the difference between
those constants? if not try reading Beg ASP 3 by Wrox it has a complete
explanation there and you can also check Ken's site www.adOpenStatic.com
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer said that
adOpenKeyset does not work on all platforms I think try searching the
archive about "why do i get -1 in recordcount" he has something said
there
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did
what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth
parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in
your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update.
Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS =3D Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") =3D Request.Form("FName")
> myRS("LName") =3D Request.Form("LName")
> myRS("Address") =3D Request.Form("Address")
> myRS("city") =3D Request.Form("City")
> myRS("State") =3D Request.Form("State")
> myRS("Zip") =3D Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS =3D Nothing
> myConn.Close
> Set myConn =3D Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #8 by "Wang, Julia" <Julia.Wang@R...> on Mon, 17 Dec 2001 09:05:15 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1870C.3BF89A30
Content-Type: text/plain;
charset="iso-8859-1"
Thanks again, Enzo. I actually just followed the sample exercise on the book
that I got from a training class. It all worked in class. Now I try to
practice in my office where apparently it does not work as well. The book
says: "the adOpenKeyset parameter allows for concurrent updates by other
users to be seen by you." and .."it is defined in the adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then from the upper left corner you ll find a text
box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use adOPenKeySet?
by the way do you really knows the difference between those constants? if
not try reading Beg ASP 3 by Wrox it has a complete explanation there and
you can also check Ken's site www.adOpenStatic.com
<http://www.adOpenStatic.com>
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer said that
adOpenKeyset does not work on all platforms I think try searching the
archive about "why do i get -1 in recordcount" he has something said there
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" < Julia.Wang@R...
<mailto:Julia.Wang@R...> >
To: "Access ASP" < access_asp@p... <mailto:access_asp@p...>
>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") = Request.Form("FName")
> myRS("LName") = Request.Form("LName")
> myRS("Address") = Request.Form("Address")
> myRS("city") = Request.Form("City")
> myRS("State") = Request.Form("State")
> myRS("Zip") = Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
$subst('Email.Unsub')
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
Message #9 by "Enzo Zaragoza" <enzaux@g...> on Mon, 17 Dec 2001 23:37:28 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_016F_01C18753.CA3BB330
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi julia,
I'm just new in ASP Im only about a year in ASP programming and Im
only 22 but i will be very glad to help you out :) I was just wondering
what do you want to do with your recordset after opening? if it's just
simply for displaying purposes only why not use adOpenForwardOnly or
adOpenstatic the others are more advanced why not just use these two to
avoid any futher errors.
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample exercise on
the book that I got >from a training class. It all worked in class. Now
I try to practice in my office where apparently it does not work as
well. The book says: "the adOpenKeyset parameter allows for concurrent
updates by other users to be seen by you." and .."it is defined in the
adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then from the upper left corner you ll find
a text box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use
adOPenKeySet? by the way do you really knows the difference between
those constants? if not try reading Beg ASP 3 by Wrox it has a complete
explanation there and you can also check Ken's site www.adOpenStatic.com
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the
archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer said
that adOpenKeyset does not work on all platforms I think try searching
the archive about "why do i get -1 in recordcount" he has something said
there
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I
did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth
parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in
your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update.
Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS =3D Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic
> myRS.AddNew
> myRS("FName") =3D Request.Form("FName")
> myRS("LName") =3D Request.Form("LName")
> myRS("Address") =3D Request.Form("Address")
> myRS("city") =3D Request.Form("City")
> myRS("State") =3D Request.Form("State")
> myRS("Zip") =3D Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS =3D Nothing
> myConn.Close
> Set myConn =3D Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp
or
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #10 by "Wang, Julia" <Julia.Wang@R...> on Mon, 17 Dec 2001 09:52:47 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C18712.DFA26ED0
Content-Type: text/plain;
charset="iso-8859-1"
Enzo,
It is a step by stey practice. It will move on to "updating records in
database", "adding and deleting records to and from a database", things like
that. So if this doesn't work, I cannot go further.
I appreciate your help! :-) Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:37 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Hi julia,
I'm just new in ASP Im only about a year in ASP programming and Im only
22 but i will be very glad to help you out :) I was just wondering what do
you want to do with your recordset after opening? if it's just simply for
displaying purposes only why not use adOpenForwardOnly or adOpenstatic the
others are more advanced why not just use these two to avoid any futher
errors.
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample exercise on the book
that I got >from a training class. It all worked in class. Now I try to
practice in my office where apparently it does not work as well. The book
says: "the adOpenKeyset parameter allows for concurrent updates by other
users to be seen by you." and .."it is defined in the adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then from the upper left corner you ll find a text
box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use adOPenKeySet?
by the way do you really knows the difference between those constants? if
not try reading Beg ASP 3 by Wrox it has a complete explanation there and
you can also check Ken's site www.adOpenStatic.com
<http://www.adOpenStatic.com>
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer said that
adOpenKeyset does not work on all platforms I think try searching the
archive about "why do i get -1 in recordcount" he has something said there
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" < Julia.Wang@R...
<mailto:Julia.Wang@R...> >
To: "Access ASP" < access_asp@p... <mailto:access_asp@p...>
>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") = Request.Form("FName")
> myRS("LName") = Request.Form("LName")
> myRS("Address") = Request.Form("Address")
> myRS("city") = Request.Form("City")
> myRS("State") = Request.Form("State")
> myRS("Zip") = Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
$subst('Email.Unsub')
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
Message #11 by "Wang, Julia" <Julia.Wang@R...> on Mon, 17 Dec 2001 09:59:05 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C18713.C1383820
Content-Type: text/plain;
charset="iso-8859-1"
Enzo, I tried using adOpenStatic. It still doesn't work. Thanks.
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:37 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Hi julia,
I'm just new in ASP Im only about a year in ASP programming and Im only
22 but i will be very glad to help you out :) I was just wondering what do
you want to do with your recordset after opening? if it's just simply for
displaying purposes only why not use adOpenForwardOnly or adOpenstatic the
others are more advanced why not just use these two to avoid any futher
errors.
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample exercise on the book
that I got >from a training class. It all worked in class. Now I try to
practice in my office where apparently it does not work as well. The book
says: "the adOpenKeyset parameter allows for concurrent updates by other
users to be seen by you." and .."it is defined in the adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then from the upper left corner you ll find a text
box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use adOPenKeySet?
by the way do you really knows the difference between those constants? if
not try reading Beg ASP 3 by Wrox it has a complete explanation there and
you can also check Ken's site www.adOpenStatic.com
<http://www.adOpenStatic.com>
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer said that
adOpenKeyset does not work on all platforms I think try searching the
archive about "why do i get -1 in recordcount" he has something said there
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" < Julia.Wang@R...
<mailto:Julia.Wang@R...> >
To: "Access ASP" < access_asp@p... <mailto:access_asp@p...>
>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") = Request.Form("FName")
> myRS("LName") = Request.Form("LName")
> myRS("Address") = Request.Form("Address")
> myRS("city") = Request.Form("City")
> myRS("State") = Request.Form("State")
> myRS("Zip") = Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
$subst('Email.Unsub')
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
Message #12 by "Enzo Zaragoza" <enzaux@g...> on Tue, 18 Dec 2001 00:12:23 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_017B_01C18758.AAEF3600
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
since you're only practicing why not use adOpenForwardOnly or
adOpenStatic inreplace for adOpenKeySet. Go ahead try it
Enzo
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 11:52 PM
Subject: [access_asp] Re: Why I cannot update RS?
Enzo,
It is a step by stey practice. It will move on to "updating records in
database", "adding and deleting records to and from a database", things
like that. So if this doesn't work, I cannot go further.
I appreciate your help! :-) Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:37 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Hi julia,
I'm just new in ASP Im only about a year in ASP programming and
Im only 22 but i will be very glad to help you out :) I was just
wondering what do you want to do with your recordset after opening? if
it's just simply for displaying purposes only why not use
adOpenForwardOnly or adOpenstatic the others are more advanced why not
just use these two to avoid any futher errors.
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample exercise
on the book that I got >from a training class. It all worked in class.
Now I try to practice in my office where apparently it does not work as
well. The book says: "the adOpenKeyset parameter allows for concurrent
updates by other users to be seen by you." and .."it is defined in the
adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then from the upper left corner you ll
find a text box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use
adOPenKeySet? by the way do you really knows the difference between
those constants? if not try reading Beg ASP 3 by Wrox it has a complete
explanation there and you can also check Ken's site www.adOpenStatic.com
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the
archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer
said that adOpenKeyset does not work on all platforms I think try
searching the archive about "why do i get -1 in recordcount" he has
something said there
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc.
But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a
fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file
adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error
'80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update.
Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS =3D Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic
> myRS.AddNew
> myRS("FName") =3D Request.Form("FName")
> myRS("LName") =3D Request.Form("LName")
> myRS("Address") =3D Request.Form("Address")
> myRS("city") =3D Request.Form("City")
> myRS("State") =3D Request.Form("State")
> myRS("Zip") =3D Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS =3D Nothing
> myConn.Close
> Set myConn =3D Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
---
Change your mail options at http://p2p.wrox.com/manager.asp
or
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #13 by "Enzo Zaragoza" <enzaux@g...> on Tue, 18 Dec 2001 00:18:34 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0187_01C18759.87D4BDB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
why not paste ur whole code here
----- Original Message -----
From: Enzo Zaragoza
To: Access ASP
Sent: Tuesday, December 18, 2001 12:12 AM
Subject: [access_asp] Re: Why I cannot update RS?
since you're only practicing why not use adOpenForwardOnly or
adOpenStatic inreplace for adOpenKeySet. Go ahead try it
Enzo
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 11:52 PM
Subject: [access_asp] Re: Why I cannot update RS?
Enzo,
It is a step by stey practice. It will move on to "updating records
in database", "adding and deleting records to and from a database",
things like that. So if this doesn't work, I cannot go further.
I appreciate your help! :-) Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:37 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Hi julia,
I'm just new in ASP Im only about a year in ASP programming and
Im only 22 but i will be very glad to help you out :) I was just
wondering what do you want to do with your recordset after opening? if
it's just simply for displaying purposes only why not use
adOpenForwardOnly or adOpenstatic the others are more advanced why not
just use these two to avoid any futher errors.
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample exercise
on the book that I got >from a training class. It all worked in class.
Now I try to practice in my office where apparently it does not work as
well. The book says: "the adOpenKeyset parameter allows for concurrent
updates by other users to be seen by you." and .."it is defined in the
adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then >from the upper left corner you
ll find a text box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use
adOPenKeySet? by the way do you really knows the difference between
those constants? if not try reading Beg ASP 3 by Wrox it has a complete
explanation there and you can also check Ken's site www.adOpenStatic.com
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the
archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer
said that adOpenKeyset does not work on all platforms I think try
searching the archive about "why do i get -1 in recordcount" he has
something said there
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc.
But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a
fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file
adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error
'80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot
update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS =3D Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic
> myRS.AddNew
> myRS("FName") =3D Request.Form("FName")
> myRS("LName") =3D Request.Form("LName")
> myRS("Address") =3D Request.Form("Address")
> myRS("city") =3D Request.Form("City")
> myRS("State") =3D Request.Form("State")
> myRS("Zip") =3D Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS =3D Nothing
> myConn.Close
> Set myConn =3D Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
---
Change your mail options at http://p2p.wrox.com/manager.asp
or
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #14 by "Wang, Julia" <Julia.Wang@R...> on Mon, 17 Dec 2001 10:45:02 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1871A.2C8779A0
Content-Type: text/plain;
charset="iso-8859-1"
Sure! Thanks for your time! :-)
<%@ LANGUAGE = "VBSCRIPT" %>
<% OPTION EXPLICIT %>
<html>
<title>Template</title>
<head>
<link rel="stylesheet" type="text/css" href="mystyles.css">
</head>
<body>
<div align="center">
<table width="600">
<tr>
<!-- #INCLUDE FILE = "header.asp" -->
</tr>
<tr>
<td valign="top">
<!-- #INCLUDE FILE = "inc/navigate.asp" -->
</td>
<td width="450" valign="top">
<!-- INSERT HERE -->
<!-- #INCLUDE FILE="adovbs.inc" -->
<!-- #INCLUDE FILE="dbconx.asp" -->
<%
Dim myRS
Set myRS = Server.CreateObject("ADODB.Recordset")
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
myRS.AddNew
myRS("FName") = Request.Form("FName")
myRS("LName") = Request.Form("LName")
myRS("Address") = Request.Form("Address")
myRS("city") = Request.Form("City")
myRS("State") = Request.Form("State")
myRS("Zip") = Request.Form("Zip")
myRS.Update
myRs.Close
Set myRS = Nothing
myConn.Close
Set myConn = Nothing
%>
<p>Record added.<br>
<a href="simplers2.asp">View Table</a></p>
</td>
</tr>
<!-- #INCLUDE FILE = "inc/footer.asp" -->
</table>
</div>
</body>
</html>
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 10:19 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
why not paste ur whole code here
----- Original Message -----
From: Enzo Zaragoza <mailto:enzaux@g...>
To: Access ASP <mailto:access_asp@p...>
Sent: Tuesday, December 18, 2001 12:12 AM
Subject: [access_asp] Re: Why I cannot update RS?
since you're only practicing why not use adOpenForwardOnly or adOpenStatic
inreplace for adOpenKeySet. Go ahead try it
Enzo
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 11:52 PM
Subject: [access_asp] Re: Why I cannot update RS?
Enzo,
It is a step by stey practice. It will move on to "updating records in
database", "adding and deleting records to and from a database", things like
that. So if this doesn't work, I cannot go further.
I appreciate your help! :-) Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:37 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Hi julia,
I'm just new in ASP Im only about a year in ASP programming and Im only
22 but i will be very glad to help you out :) I was just wondering what do
you want to do with your recordset after opening? if it's just simply for
displaying purposes only why not use adOpenForwardOnly or adOpenstatic the
others are more advanced why not just use these two to avoid any futher
errors.
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample exercise on the book
that I got >from a training class. It all worked in class. Now I try to
practice in my office where apparently it does not work as well. The book
says: "the adOpenKeyset parameter allows for concurrent updates by other
users to be seen by you." and .."it is defined in the adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then >from the upper left corner you ll find a text
box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use adOPenKeySet?
by the way do you really knows the difference between those constants? if
not try reading Beg ASP 3 by Wrox it has a complete explanation there and
you can also check Ken's site www.adOpenStatic.com
<http://www.adOpenStatic.com>
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer said that
adOpenKeyset does not work on all platforms I think try searching the
archive about "why do i get -1 in recordcount" he has something said there
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" < Julia.Wang@R...
<mailto:Julia.Wang@R...> >
To: "Access ASP" < access_asp@p... <mailto:access_asp@p...>
>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") = Request.Form("FName")
> myRS("LName") = Request.Form("LName")
> myRS("Address") = Request.Form("Address")
> myRS("city") = Request.Form("City")
> myRS("State") = Request.Form("State")
> myRS("Zip") = Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
$subst('Email.Unsub')
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
Message #15 by "Enzo Zaragoza" <enzaux@g...> on Tue, 18 Dec 2001 01:12:47 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0199_01C18761.1ADEA1A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Be sure you have your connection (myConn Opened) then do this:
myRS.Open "Customers", myConn, adOpenStatic, adLockOptimistic,
adCmdTable
Go ahead try it
enzo
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Tuesday, December 18, 2001 12:45 AM
Subject: [access_asp] Re: Why I cannot update RS?
Sure! Thanks for your time! :-)
<%@ LANGUAGE =3D "VBSCRIPT" %>
<% OPTION EXPLICIT %>
<html>
<title>Template</title>
<head>
<link rel=3D"stylesheet" type=3D"text/css" href=3D"mystyles.css">
</head>
<body>
<div align=3D"center">
<table width=3D"600">
<tr>
<!-- #INCLUDE FILE =3D "header.asp" -->
</tr>
<tr>
<td valign=3D"top">
<!-- #INCLUDE FILE =3D "inc/navigate.asp" -->
</td>
<td width=3D"450" valign=3D"top">
<!-- INSERT HERE -->
<!-- #INCLUDE FILE=3D"adovbs.inc" -->
<!-- #INCLUDE FILE=3D"dbconx.asp" -->
<%
Dim myRS
Set myRS =3D Server.CreateObject("ADODB.Recordset")
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
myRS.AddNew
myRS("FName") =3D Request.Form("FName")
myRS("LName") =3D Request.Form("LName")
myRS("Address") =3D Request.Form("Address")
myRS("city") =3D Request.Form("City")
myRS("State") =3D Request.Form("State")
myRS("Zip") =3D Request.Form("Zip")
myRS.Update
myRs.Close
Set myRS =3D Nothing
myConn.Close
Set myConn =3D Nothing
%>
<p>Record added.<br>
<a href=3D"simplers2.asp">View Table</a></p>
</td>
</tr>
<!-- #INCLUDE FILE =3D "inc/footer.asp" -->
</table>
</div>
</body>
</html>
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 10:19 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
why not paste ur whole code here
----- Original Message -----
From: Enzo Zaragoza
To: Access ASP
Sent: Tuesday, December 18, 2001 12:12 AM
Subject: [access_asp] Re: Why I cannot update RS?
since you're only practicing why not use adOpenForwardOnly or
adOpenStatic inreplace for adOpenKeySet. Go ahead try it
Enzo
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 11:52 PM
Subject: [access_asp] Re: Why I cannot update RS?
Enzo,
It is a step by stey practice. It will move on to "updating
records in database", "adding and deleting records to and from a
database", things like that. So if this doesn't work, I cannot go
further.
I appreciate your help! :-) Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:37 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Hi julia,
I'm just new in ASP Im only about a year in ASP programming
and Im only 22 but i will be very glad to help you out :) I was just
wondering what do you want to do with your recordset after opening? if
it's just simply for displaying purposes only why not use
adOpenForwardOnly or adOpenstatic the others are more advanced why not
just use these two to avoid any futher errors.
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample
exercise on the book that I got >from a training class. It all worked in
class. Now I try to practice in my office where apparently it does not
work as well. The book says: "the adOpenKeyset parameter allows for
concurrent updates by other users to be seen by you." and .."it is
defined in the adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then >from the upper left corner
you ll find a text box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to
use adOPenKeySet? by the way do you really knows the difference between
those constants? if not try reading Beg ASP 3 by Wrox it has a complete
explanation there and you can also check Ken's site www.adOpenStatic.com
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to
the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken
Schaefer said that adOpenKeyset does not work on all platforms I think
try searching the archive about "why do i get -1 in recordcount" he has
something said there
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the
adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting
[mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command
needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file
adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error
'80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot
update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS =3D
Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic
> myRS.AddNew
> myRS("FName") =3D Request.Form("FName")
> myRS("LName") =3D Request.Form("LName")
> myRS("Address") =3D Request.Form("Address")
> myRS("city") =3D Request.Form("City")
> myRS("State") =3D Request.Form("State")
> myRS("Zip") =3D Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS =3D Nothing
> myConn.Close
> Set myConn =3D Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
---
Change your mail options at http://p2p.wrox.com/manager.asp
or
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #16 by "Wang, Julia" <Julia.Wang@R...> on Mon, 17 Dec 2001 11:51:05 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C18723.66477A10
Content-Type: text/plain;
charset="iso-8859-1"
I am so sorry. It is still the same error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object
is read-only.
Could it be something set up in the database? It shouldn't be as it worked
ok before.
Julia
Julia -----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 11:13 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Be sure you have your connection (myConn Opened) then do this:
myRS.Open "Customers", myConn, adOpenStatic, adLockOptimistic, adCmdTable
Go ahead try it
enzo
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Tuesday, December 18, 2001 12:45 AM
Subject: [access_asp] Re: Why I cannot update RS?
Sure! Thanks for your time! :-)
<%@ LANGUAGE = "VBSCRIPT" %>
<% OPTION EXPLICIT %>
<html>
<title>Template</title>
<head>
<link rel="stylesheet" type="text/css" href="mystyles.css">
</head>
<body>
<div align="center">
<table width="600">
<tr>
<!-- #INCLUDE FILE = "header.asp" -->
</tr>
<tr>
<td valign="top">
<!-- #INCLUDE FILE = "inc/navigate.asp" -->
</td>
<td width="450" valign="top">
<!-- INSERT HERE -->
<!-- #INCLUDE FILE="adovbs.inc" -->
<!-- #INCLUDE FILE="dbconx.asp" -->
<%
Dim myRS
Set myRS = Server.CreateObject("ADODB.Recordset")
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
myRS.AddNew
myRS("FName") = Request.Form("FName")
myRS("LName") = Request.Form("LName")
myRS("Address") = Request.Form("Address")
myRS("city") = Request.Form("City")
myRS("State") = Request.Form("State")
myRS("Zip") = Request.Form("Zip")
myRS.Update
myRs.Close
Set myRS = Nothing
myConn.Close
Set myConn = Nothing
%>
<p>Record added.<br>
<a href="simplers2.asp">View Table</a></p>
</td>
</tr>
<!-- #INCLUDE FILE = "inc/footer.asp" -->
</table>
</div>
</body>
</html>
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 10:19 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
why not paste ur whole code here
----- Original Message -----
From: Enzo Zaragoza <mailto:enzaux@g...>
To: Access ASP <mailto:access_asp@p...>
Sent: Tuesday, December 18, 2001 12:12 AM
Subject: [access_asp] Re: Why I cannot update RS?
since you're only practicing why not use adOpenForwardOnly or adOpenStatic
inreplace for adOpenKeySet. Go ahead try it
Enzo
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 11:52 PM
Subject: [access_asp] Re: Why I cannot update RS?
Enzo,
It is a step by stey practice. It will move on to "updating records in
database", "adding and deleting records to and from a database", things like
that. So if this doesn't work, I cannot go further.
I appreciate your help! :-) Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:37 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Hi julia,
I'm just new in ASP Im only about a year in ASP programming and Im only
22 but i will be very glad to help you out :) I was just wondering what do
you want to do with your recordset after opening? if it's just simply for
displaying purposes only why not use adOpenForwardOnly or adOpenstatic the
others are more advanced why not just use these two to avoid any futher
errors.
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample exercise on the book
that I got >from a training class. It all worked in class. Now I try to
practice in my office where apparently it does not work as well. The book
says: "the adOpenKeyset parameter allows for concurrent updates by other
users to be seen by you." and .."it is defined in the adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then >from the upper left corner you ll find a text
box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use adOPenKeySet?
by the way do you really knows the difference between those constants? if
not try reading Beg ASP 3 by Wrox it has a complete explanation there and
you can also check Ken's site www.adOpenStatic.com
<http://www.adOpenStatic.com>
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer said that
adOpenKeyset does not work on all platforms I think try searching the
archive about "why do i get -1 in recordcount" he has something said there
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" < Julia.Wang@R...
<mailto:Julia.Wang@R...> >
To: "Access ASP" < access_asp@p... <mailto:access_asp@p...>
>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
> myRS.AddNew
> myRS("FName") = Request.Form("FName")
> myRS("LName") = Request.Form("LName")
> myRS("Address") = Request.Form("Address")
> myRS("city") = Request.Form("City")
> myRS("State") = Request.Form("State")
> myRS("Zip") = Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS = Nothing
> myConn.Close
> Set myConn = Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
$subst('Email.Unsub')
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
---
Change your mail options at http://p2p.wrox.com/manager.asp
<http://p2p.wrox.com/manager.asp> or
<mailto:$subst('Email.Unsub')> .
Message #17 by "Enzo Zaragoza" <enzaux@g...> on Tue, 18 Dec 2001 02:09:42 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_01E7_01C18769.0E4DA550
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
May be your table is opened or set to read only thats why it cant be
updated. Try closing your database first.
if not, try creating a sql that would get all you need from the table
then change your statement like this
strSQL =3D "SELECT * FROM Customers;"
myRS.Open strSQL, myConn, adOpenStatic, adLockOptimistic, adCmdText
Enzo
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Tuesday, December 18, 2001 1:51 AM
Subject: [access_asp] Re: Why I cannot update RS?
I am so sorry. It is still the same error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object is read-only.
Could it be something set up in the database? It shouldn't be as it
worked ok before.
Julia
Julia -----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 11:13 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Be sure you have your connection (myConn Opened) then do this:
myRS.Open "Customers", myConn, adOpenStatic, adLockOptimistic,
adCmdTable
Go ahead try it
enzo
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Tuesday, December 18, 2001 12:45 AM
Subject: [access_asp] Re: Why I cannot update RS?
Sure! Thanks for your time! :-)
<%@ LANGUAGE =3D "VBSCRIPT" %>
<% OPTION EXPLICIT %>
<html>
<title>Template</title>
<head>
<link rel=3D"stylesheet" type=3D"text/css" href=3D"mystyles.css">
</head>
<body>
<div align=3D"center">
<table width=3D"600">
<tr>
<!-- #INCLUDE FILE =3D "header.asp" -->
</tr>
<tr>
<td valign=3D"top">
<!-- #INCLUDE FILE =3D "inc/navigate.asp" -->
</td>
<td width=3D"450" valign=3D"top">
<!-- INSERT HERE -->
<!-- #INCLUDE FILE=3D"adovbs.inc" -->
<!-- #INCLUDE FILE=3D"dbconx.asp" -->
<%
Dim myRS
Set myRS =3D Server.CreateObject("ADODB.Recordset")
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
myRS.AddNew
myRS("FName") =3D Request.Form("FName")
myRS("LName") =3D Request.Form("LName")
myRS("Address") =3D Request.Form("Address")
myRS("city") =3D Request.Form("City")
myRS("State") =3D Request.Form("State")
myRS("Zip") =3D Request.Form("Zip")
myRS.Update
myRs.Close
Set myRS =3D Nothing
myConn.Close
Set myConn =3D Nothing
%>
<p>Record added.<br>
<a href=3D"simplers2.asp">View Table</a></p>
</td>
</tr>
<!-- #INCLUDE FILE =3D "inc/footer.asp" -->
</table>
</div>
</body>
</html>
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 10:19 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
why not paste ur whole code here
----- Original Message -----
From: Enzo Zaragoza
To: Access ASP
Sent: Tuesday, December 18, 2001 12:12 AM
Subject: [access_asp] Re: Why I cannot update RS?
since you're only practicing why not use adOpenForwardOnly or
adOpenStatic inreplace for adOpenKeySet. Go ahead try it
Enzo
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 11:52 PM
Subject: [access_asp] Re: Why I cannot update RS?
Enzo,
It is a step by stey practice. It will move on to "updating
records in database", "adding and deleting records to and from a
database", things like that. So if this doesn't work, I cannot go
further.
I appreciate your help! :-) Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:37 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Hi julia,
I'm just new in ASP Im only about a year in ASP
programming and Im only 22 but i will be very glad to help you out :) I
was just wondering what do you want to do with your recordset after
opening? if it's just simply for displaying purposes only why not use
adOpenForwardOnly or adOpenstatic the others are more advanced why not
just use these two to avoid any futher errors.
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample
exercise on the book that I got >from a training class. It all worked in
class. Now I try to practice in my office where apparently it does not
work as well. The book says: "the adOpenKeyset parameter allows for
concurrent updates by other users to be seen by you." and .."it is
defined in the adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then >from the upper left
corner you ll find a text box asking for your search string then click
Go
Why not use adOpenStatic? is it really needed for you
to use adOPenKeySet? by the way do you really knows the difference
between those constants? if not try reading Beg ASP 3 by Wrox it has a
complete explanation there and you can also check Ken's site
www.adOpenStatic.com
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get
to the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken
Schaefer said that adOpenKeyset does not work on all platforms I think
try searching the archive about "why do i get -1 in recordcount" he has
something said there
Enzo :)
----- Original Message -----
From: Wang, Julia
To: Access ASP
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update
RS?
Thanks again, Zee. Yes, I have included the
adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting
[mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update
RS?
Julia,
Possible cause: Your recordset-open command
needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn,
adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file
adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" <Julia.Wang@R...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> ERROR---
> Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver]
Cannot update. Database or
object
> is read-only.
>
> CODE----
> <%
> Dim myRS
> Set myRS =3D
Server.CreateObject("ADODB.Recordset")
> myRS.Open "Customers", myConn, adOpenKeyset,
adLockOptimistic
> myRS.AddNew
> myRS("FName") =3D Request.Form("FName")
> myRS("LName") =3D Request.Form("LName")
> myRS("Address") =3D Request.Form("Address")
> myRS("city") =3D Request.Form("City")
> myRS("State") =3D Request.Form("State")
> myRS("Zip") =3D Request.Form("Zip")
> myRS.Update
> myRs.Close
> Set myRS =3D Nothing
> myConn.Close
> Set myConn =3D Nothing
> %>
> <*><*><*><*><*><*><*><*><*><*>
>
> Thanks,
> Julia
>
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
---
Change your mail options at http://p2p.wrox.com/manager.asp
or
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #18 by "Wang, Julia" <Julia.Wang@R...> on Mon, 17 Dec 2001 12:41:02 -0600
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1872A.60DF55F0
Content-Type: text/plain;
charset="iso-8859-1"
I am not familiar with SQL yet. Do I need to change the rest of the code as
well? Thanks!
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 12:10 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
May be your table is opened or set to read only thats why it cant be
updated. Try closing your database first.
if not, try creating a sql that would get all you need from the table then
change your statement like this
strSQL = "SELECT * FROM Customers;"
myRS.Open strSQL, myConn, adOpenStatic, adLockOptimistic, adCmdText
Enzo
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Tuesday, December 18, 2001 1:51 AM
Subject: [access_asp] Re: Why I cannot update RS?
I am so sorry. It is still the same error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object
is read-only.
Could it be something set up in the database? It shouldn't be as it worked
ok before.
Julia
Julia -----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 11:13 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Be sure you have your connection (myConn Opened) then do this:
myRS.Open "Customers", myConn, adOpenStatic, adLockOptimistic, adCmdTable
Go ahead try it
enzo
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Tuesday, December 18, 2001 12:45 AM
Subject: [access_asp] Re: Why I cannot update RS?
Sure! Thanks for your time! :-)
<%@ LANGUAGE = "VBSCRIPT" %>
<% OPTION EXPLICIT %>
<html>
<title>Template</title>
<head>
<link rel="stylesheet" type="text/css" href="mystyles.css">
</head>
<body>
<div align="center">
<table width="600">
<tr>
<!-- #INCLUDE FILE = "header.asp" -->
</tr>
<tr>
<td valign="top">
<!-- #INCLUDE FILE = "inc/navigate.asp" -->
</td>
<td width="450" valign="top">
<!-- INSERT HERE -->
<!-- #INCLUDE FILE="adovbs.inc" -->
<!-- #INCLUDE FILE="dbconx.asp" -->
<%
Dim myRS
Set myRS = Server.CreateObject("ADODB.Recordset")
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic
myRS.AddNew
myRS("FName") = Request.Form("FName")
myRS("LName") = Request.Form("LName")
myRS("Address") = Request.Form("Address")
myRS("city") = Request.Form("City")
myRS("State") = Request.Form("State")
myRS("Zip") = Request.Form("Zip")
myRS.Update
myRs.Close
Set myRS = Nothing
myConn.Close
Set myConn = Nothing
%>
<p>Record added.<br>
<a href="simplers2.asp">View Table</a></p>
</td>
</tr>
<!-- #INCLUDE FILE = "inc/footer.asp" -->
</table>
</div>
</body>
</html>
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 10:19 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
why not paste ur whole code here
----- Original Message -----
From: Enzo <mailto:enzaux@g...> Zaragoza
To: Access ASP <mailto:access_asp@p...>
Sent: Tuesday, December 18, 2001 12:12 AM
Subject: [access_asp] Re: Why I cannot update RS?
since you're only practicing why not use adOpenForwardOnly or adOpenStatic
inreplace for adOpenKeySet. Go ahead try it
Enzo
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 11:52 PM
Subject: [access_asp] Re: Why I cannot update RS?
Enzo,
It is a step by stey practice. It will move on to "updating records in
database", "adding and deleting records to and from a database", things like
that. So if this doesn't work, I cannot go further.
I appreciate your help! :-) Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:37 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Hi julia,
I'm just new in ASP Im only about a year in ASP programming and Im only
22 but i will be very glad to help you out :) I was just wondering what do
you want to do with your recordset after opening? if it's just simply for
displaying purposes only why not use adOpenForwardOnly or adOpenstatic the
others are more advanced why not just use these two to avoid any futher
errors.
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 11:05 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Enzo. I actually just followed the sample exercise on the book
that I got >from a training class. It all worked in class. Now I try to
practice in my office where apparently it does not work as well. The book
says: "the adOpenKeyset parameter allows for concurrent updates by other
users to be seen by you." and .."it is defined in the adovbs.inc file .."
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 9:09 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
just go to p2p.wrox.com then >from the upper left corner you ll find a text
box asking for your search string then click Go
Why not use adOpenStatic? is it really needed for you to use adOPenKeySet?
by the way do you really knows the difference between those constants? if
not try reading Beg ASP 3 by Wrox it has a complete explanation there and
you can also check Ken's site www.adOpenStatic.com
<http://www.adOpenStatic.com>
Enzo:)
PS
Research more to get answers to your questions :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:45 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks a lot, Enzo. Could you instruct me how to get to the archive?
Julia
<*><*><*><*><*><*><*><*><*><*>
-----Original Message-----
From: Enzo Zaragoza [mailto:enzaux@g...]
Sent: Monday, December 17, 2001 8:53 AM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Oh may be adOpenKeyset hs the problem because Ken Schaefer said that
adOpenKeyset does not work on all platforms I think try searching the
archive about "why do i get -1 in recordcount" he has something said there
Enzo :)
----- Original Message -----
From: Wang, Julia <mailto:Julia.Wang@R...>
To: Access ASP <mailto:access_asp@p...>
Sent: Monday, December 17, 2001 10:28 PM
Subject: [access_asp] Re: Why I cannot update RS?
Thanks again, Zee. Yes, I have included the adovbs.inc. But I did what you
suggested and this is the error message I got.
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.
<*><*><*><*><*><*><*><*><*><*>
Julia
-----Original Message-----
From: Zee Computer Consulting [mailto:zee@t...]
Sent: Friday, December 14, 2001 10:24 PM
To: Access ASP
Subject: [access_asp] Re: Why I cannot update RS?
Julia,
Possible cause: Your recordset-open command needs a fifth parameter to
indicate that you are opening an entire table:
myRS.Open "Customers", myConn, adOpenKeyset, adLockOptimistic,
adCmdTable
(I am assuning that you have "included" the file adovbs.inc in your pages,
where adCmdTable is defined.) Does this help?
Z
----- Original Message -----
From: "Wang, Julia" < Julia.Wang@R...
<mailto:Julia.Wang@R...> >
To: "Access ASP" < access_asp@p... <mailto:access_asp@p...>
>
Sent: Friday, December 14, 2001 11:33 AM
Subject: [access_asp] Why I cannot update RS?
> Some one pls help me!
>
> | |
View Cart
