|
 |
asp_databases thread: problem with insert data into database
Message #1 by derekwong600@h... on Tue, 26 Mar 2002 22:04:34
|
|
when I ran the code, the browser always had this error....can any one
help me to solve the problem..
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/schedule/addPAge.asp, line 16
the following is my code.
<%
Dim objConn2,objRS2 set objConn2 = Server.CreateObject
("ADODB.Connection")
objConn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False"
Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn,
adOpenStatic ,adLockOptimistic ,adCmdTable ' LINE 16
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
Message #2 by "Derek" <derekwong600@h...> on Tue, 26 Mar 2002 14:00:08 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00B6_01C1D4CE.89E98AA0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
when I ran the code, the browser always had this error....can any one
help me to solve the problem..
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/schedule/addPAge.asp, line 16
the following is my code. ( I also attach my database)
<%
Dim objConn2,objRS2 set objConn2 =3D
Server.CreateObject("ADODB.Connection")
objConn2.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;Data
Source=3DC:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=3DFalse"
Set objRS2 =3D Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn, adOpenStatic ,adLockOptimistic
,adCmdTable ' LINE 16
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")=3D "getStartDate"
objRS2("EndDate") =3D "getEndDate"
objRS2("Content") =3D "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 =3D nothing
set objConn2 =3Dnothing
%>
Message #3 by "Drew, Ron" <RDrew@B...> on Tue, 26 Mar 2002 17:33:51 -0500
|
|
Do you have the following at the top of your asp?? The include sets up
your ADO constants adOpenStatic etc..
<%Option Explicit%>
<!-- #include file=3D"adovbs.inc" -->
-----Original Message-----
From: derekwong600@h... [mailto:derekwong600@h...]
Sent: Tuesday, March 26, 2002 5:05 PM
To: ASP Databases
Subject: [asp_databases] problem with insert data into database
when I ran the code, the browser always had this error....can any one
help me to solve the problem..
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/schedule/addPAge.asp, line 16
the following is my code.
<%
Dim objConn2,objRS2 set objConn2 =3D Server.CreateObject
("ADODB.Connection")
objConn2.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;Data
Source=3DC:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=3DFalse"
Set objRS2 =3D Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn,
adOpenStatic ,adLockOptimistic ,adCmdTable ' LINE 16
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")=3D "getStartDate"
objRS2("EndDate") =3D "getEndDate"
objRS2("Content") =3D "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 =3D nothing
set objConn2 =3Dnothing
%>
Message #4 by "Derek" <derekwong600@h...> on Tue, 26 Mar 2002 20:30:11 -0800
|
|
where can I get the file "adovbs.inc"
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, March 26, 2002 2:33 PM
Subject: [asp_databases] RE: problem with insert data into database
Do you have the following at the top of your asp?? The include sets up
your ADO constants adOpenStatic etc..
<%Option Explicit%>
<!-- #include file="adovbs.inc" -->
-----Original Message-----
From: derekwong600@h... [mailto:derekwong600@h...]
Sent: Tuesday, March 26, 2002 5:05 PM
To: ASP Databases
Subject: [asp_databases] problem with insert data into database
when I ran the code, the browser always had this error....can any one
help me to solve the problem..
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/schedule/addPAge.asp, line 16
the following is my code.
<%
Dim objConn2,objRS2 set objConn2 = Server.CreateObject
("ADODB.Connection")
objConn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False"
Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn,
adOpenStatic ,adLockOptimistic ,adCmdTable ' LINE 16
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
Message #5 by arshad siddiqui <ash_arshad@y...> on Tue, 26 Mar 2002 21:00:25 -0800 (PST)
|
|
Hi,
It might be due to the wrong or unmatchable argument
used in line 16.
Try using objRS2.open instead of the whole line.I hope
it works.
Still any problem,let me know.
Thanks
--Arshad-
--- derekwong600@h... wrote:
> when I ran the code, the browser always had this
> error....can any one
> help me to solve the problem..
>
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of
> acceptable range, or are in
> conflict with one another.
> /schedule/addPAge.asp, line 16
>
>
> the following is my code.
> <%
> Dim objConn2,objRS2 set objConn2
> Server.CreateObject
> ("ADODB.Connection")
> objConn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
>
>
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist
> Security
> info=False"
> Set objRS2 = Server.CreateObject ("ADODB.Recordset")
>
> objRS2.Open "adminContent", objConn,
> adOpenStatic ,adLockOptimistic ,adCmdTable '
> LINE 16
> objRS2.MoveLast
> objRS2.AddNew
> objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
>
> %>
__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
Message #6 by "Derek" <derekwong600@h...> on Tue, 26 Mar 2002 23:16:04 -0800
|
|
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/schedule/addPAge.asp, line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection")
objConn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False"
Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
Message #7 by arshad siddiqui <ash_arshad@y...> on Wed, 27 Mar 2002 02:16:40 -0800 (PST)
|
|
Hi,
Right click on your database and go to properties and
uncheck the hidden and read only boxes.then try
running the script.
Hope this works.
--Arshad--
--- Derek <derekwong600@h...> wrote:
> This time the error is this :
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only.
> /schedule/addPAge.asp, line 18
>
> so what is that mean and how can I fix it
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject
> ("ADODB.Connection")
> objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
>
>
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist
> Security
> info=False"
> Set objRS2 = Server.CreateObject
> ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic
> ,adLockOptimistic
> ,adCmdTable '
> objRS2.MoveLast
> objRS2.AddNew
> objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
Message #8 by "Drew, Ron" <RDrew@B...> on Wed, 27 Mar 2002 08:18:29 -0500
|
|
http://www.4guysfromrolla.com/aspfaqs/ShowFAQ.asp?FAQID=3D123
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Tuesday, March 26, 2002 11:30 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
where can I get the file "adovbs.inc"
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, March 26, 2002 2:33 PM
Subject: [asp_databases] RE: problem with insert data into database
Do you have the following at the top of your asp?? The include sets up
your ADO constants adOpenStatic etc.. <%Option Explicit%>
<!-- #include file=3D"adovbs.inc" -->
-----Original Message-----
From: derekwong600@h... [mailto:derekwong600@h...]
Sent: Tuesday, March 26, 2002 5:05 PM
To: ASP Databases
Subject: [asp_databases] problem with insert data into database
when I ran the code, the browser always had this error....can any one
help me to solve the problem..
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another. /schedule/addPAge.asp, line 16
the following is my code.
<%
Dim objConn2,objRS2 set objConn2 =3D Server.CreateObject
("ADODB.Connection")
objConn2.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;Data
Source=3DC:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=3DFalse" Set objRS2 =3D Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn,
adOpenStatic ,adLockOptimistic ,adCmdTable ' LINE 16
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")=3D "getStartDate"
objRS2("EndDate") =3D "getEndDate"
objRS2("Content") =3D "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 =3D nothing
set objConn2 =3Dnothing
%>
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #9 by "Drew, Ron" <RDrew@B...> on Wed, 27 Mar 2002 08:51:24 -0500
|
|
This is an example AddNew adds..no need to move to the last...check the
cursors on this one...example uses an autoID.
objRS.Open
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
objRS.AddNew
objRS.Fields("column1") =3D strcolumn1
objRS.Fields("column2") =3D strcolumn2
objRS.Update
intID =3D objRS("appid")
Response.Write "<p>Record ID " & intID & " added!!</p>"
objRS.Close
set objRS =3D Nothing
yourconnection.Close
set yourconnection =3D Nothing
set intID =3D Nothing
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Wednesday, March 27, 2002 2:16 AM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file =3D "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 =3D Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Data
Source=3DC:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=3DFalse" Set objRS2 =3D Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")=3D "getStartDate"
objRS2("EndDate") =3D "getEndDate"
objRS2("Content") =3D "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 =3D nothing
set objConn2 =3Dnothing
%>
Message #10 by "Patrick Sullivan" <pat@s...> on Thu, 28 Mar 2002 17:02:09 -0600
|
|
Hmm then it should be there...can't really think of anything else, when
you right click the mdb you should see a series of Tabs at the top of
the properties window (General, Security, Summary) click the security
tab and that's where you need to change things, also make sure you have
the db open in shared mode, not exclusive mode, you can see this in the
access db by clicking tools/options then going to the advanced tab.
If none of that works I am at a loss.
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 4:55 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
NTFS
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:36 PM
Subject: [asp_databases] RE: problem with insert data into database
> Is the drive the mdb is on a Fat32 drive or ntfs?
>
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 4:27 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> I can't see any "security tap" but the I am sure that the readonly
isn't
> checked
>
>
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, March 28, 2002 2:09 PM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> OK..you changed the adOpenStatic to adOpenForwardOnly
> 1. go to the directory the MDB is in and right click, make sure it is
> not readonly, click on security and give EVERYONE full control.
>
> 2. the example below has objRS2("EndDate") = "getEndDate" if
> EndDate is a date, why are you setting it to the literal "getEndDate"?
> Is getEndDate coming from a form? If so, objRS2("EndDate")
> request.form("getEndDate")
>
> ...If you did a request form to the literal getEndDate
> getEndDate = request.form("myenddateonform")
> objRS2("EndDate") = getEndDate
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 4:24 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> I checked my code , but I don't know what is the problem it
>
>
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> line 18
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
>
>
>
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Wednesday, March 27, 2002 5:51 AM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This is an example AddNew adds..no need to move to the last...check
the
> cursors on this one...example uses an autoID.
>
> objRS.Open
>
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> objRS.AddNew
> objRS.Fields("column1") = strcolumn1
> objRS.Fields("column2") = strcolumn2
> objRS.Update
> intID = objRS("appid")
> Response.Write "<p>Record ID " & intID & " added!!</p>"
>
> objRS.Close
> set objRS = Nothing
> yourconnection.Close
> set yourconnection = Nothing
> set intID = Nothing
>
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Wednesday, March 27, 2002 2:16 AM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This time the error is this :
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> line 18
>
> so what is that mean and how can I fix it
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable '
> objRS2.MoveLast
> objRS2.AddNew
> objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>
>
>
>
>
>
>
>
>
Message #11 by "Derek" <derekwong600@h...> on Thu, 28 Mar 2002 13:23:54 -0800
|
|
I checked my code , but I don't know what is the problem it
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/schedule/addPAge.asp, line 18
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False"
Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, March 27, 2002 5:51 AM
Subject: [asp_databases] RE: problem with insert data into database
This is an example AddNew adds..no need to move to the last...check the
cursors on this one...example uses an autoID.
objRS.Open
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
objRS.AddNew
objRS.Fields("column1") = strcolumn1
objRS.Fields("column2") = strcolumn2
objRS.Update
intID = objRS("appid")
Response.Write "<p>Record ID " & intID & " added!!</p>"
objRS.Close
set objRS = Nothing
yourconnection.Close
set yourconnection = Nothing
set intID = Nothing
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Wednesday, March 27, 2002 2:16 AM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
Message #12 by "Patrick Sullivan" <pat@s...> on Thu, 28 Mar 2002 15:30:03 -0600
|
|
What kind of database are we talking about?
Seems to me that, if there is insufficient permissions on the db, jet
should be returning something like "must use updatable query". Has to be
the recordset - you may need to change that adOpenStatic to
adOpenForwardOnly....
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 3:24 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I checked my code , but I don't know what is the problem it
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/schedule/addPAge.asp, line 18
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False"
Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, March 27, 2002 5:51 AM
Subject: [asp_databases] RE: problem with insert data into database
This is an example AddNew adds..no need to move to the last...check the
cursors on this one...example uses an autoID.
objRS.Open
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
objRS.AddNew
objRS.Fields("column1") = strcolumn1
objRS.Fields("column2") = strcolumn2
objRS.Update
intID = objRS("appid")
Response.Write "<p>Record ID " & intID & " added!!</p>"
objRS.Close
set objRS = Nothing
yourconnection.Close
set yourconnection = Nothing
set intID = Nothing
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Wednesday, March 27, 2002 2:16 AM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
Message #13 by "Derek" <derekwong600@h...> on Thu, 28 Mar 2002 13:35:37 -0800
|
|
I changed it , but it still have the same problem..
I am now using the Access 97 for my Database
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 1:30 PM
Subject: [asp_databases] RE: problem with insert data into database
> What kind of database are we talking about?
>
> Seems to me that, if there is insufficient permissions on the db, jet
> should be returning something like "must use updatable query". Has to be
> the recordset - you may need to change that adOpenStatic to
> adOpenForwardOnly....
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 3:24 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> I checked my code , but I don't know what is the problem it
>
>
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only.
> /schedule/addPAge.asp, line 18
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False"
> Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable
> objRS2.AddNew
> objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
>
>
>
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Wednesday, March 27, 2002 5:51 AM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This is an example AddNew adds..no need to move to the last...check the
> cursors on this one...example uses an autoID.
>
> objRS.Open
> "yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> objRS.AddNew
> objRS.Fields("column1") = strcolumn1
> objRS.Fields("column2") = strcolumn2
> objRS.Update
> intID = objRS("appid")
> Response.Write "<p>Record ID " & intID & " added!!</p>"
>
> objRS.Close
> set objRS = Nothing
> yourconnection.Close
> set yourconnection = Nothing
> set intID = Nothing
>
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Wednesday, March 27, 2002 2:16 AM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This time the error is this :
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> line 18
>
> so what is that mean and how can I fix it
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable '
> objRS2.MoveLast
> objRS2.AddNew
> objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
>
>
>
>
>
>
>
Message #14 by "Patrick Sullivan" <pat@s...> on Thu, 28 Mar 2002 15:45:10 -0600
|
|
Hmm do oyu have control of the permissions for the database?
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 3:36 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I changed it , but it still have the same problem..
I am now using the Access 97 for my Database
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 1:30 PM
Subject: [asp_databases] RE: problem with insert data into database
> What kind of database are we talking about?
>
> Seems to me that, if there is insufficient permissions on the db, jet
> should be returning something like "must use updatable query". Has to
be
> the recordset - you may need to change that adOpenStatic to
> adOpenForwardOnly....
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 3:24 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> I checked my code , but I don't know what is the problem it
>
>
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only.
> /schedule/addPAge.asp, line 18
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False"
> Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable
> objRS2.AddNew
> objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
>
>
>
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Wednesday, March 27, 2002 5:51 AM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This is an example AddNew adds..no need to move to the last...check
the
> cursors on this one...example uses an autoID.
>
> objRS.Open
>
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> objRS.AddNew
> objRS.Fields("column1") = strcolumn1
> objRS.Fields("column2") = strcolumn2
> objRS.Update
> intID = objRS("appid")
> Response.Write "<p>Record ID " & intID & " added!!</p>"
>
> objRS.Close
> set objRS = Nothing
> yourconnection.Close
> set yourconnection = Nothing
> set intID = Nothing
>
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Wednesday, March 27, 2002 2:16 AM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This time the error is this :
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> line 18
>
> so what is that mean and how can I fix it
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable '
> objRS2.MoveLast
> objRS2.AddNew
> objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
>
>
>
>
>
>
>
Message #15 by "Derek" <derekwong600@h...> on Thu, 28 Mar 2002 13:49:37 -0800
|
|
U know I am very green, so where can I find it?
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 1:45 PM
Subject: [asp_databases] RE: problem with insert data into database
> Hmm do oyu have control of the permissions for the database?
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 3:36 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> I changed it , but it still have the same problem..
> I am now using the Access 97 for my Database
> ----- Original Message -----
> From: "Patrick Sullivan" <pat@s...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, March 28, 2002 1:30 PM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> > What kind of database are we talking about?
> >
> > Seems to me that, if there is insufficient permissions on the db, jet
> > should be returning something like "must use updatable query". Has to
> be
> > the recordset - you may need to change that adOpenStatic to
> > adOpenForwardOnly....
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Thursday, March 28, 2002 3:24 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> > I checked my code , but I don't know what is the problem it
> >
> >
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only.
> > /schedule/addPAge.asp, line 18
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> > info=False"
> > Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable
> > objRS2.AddNew
> > objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Drew, Ron" <RDrew@B...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Wednesday, March 27, 2002 5:51 AM
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This is an example AddNew adds..no need to move to the last...check
> the
> > cursors on this one...example uses an autoID.
> >
> > objRS.Open
> >
> "yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> > objRS.AddNew
> > objRS.Fields("column1") = strcolumn1
> > objRS.Fields("column2") = strcolumn2
> > objRS.Update
> > intID = objRS("appid")
> > Response.Write "<p>Record ID " & intID & " added!!</p>"
> >
> > objRS.Close
> > set objRS = Nothing
> > yourconnection.Close
> > set yourconnection = Nothing
> > set intID = Nothing
> >
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Wednesday, March 27, 2002 2:16 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This time the error is this :
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> > line 18
> >
> > so what is that mean and how can I fix it
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> > info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable '
> > objRS2.MoveLast
> > objRS2.AddNew
> > objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
Message #16 by "Patrick Sullivan" <pat@s...> on Thu, 28 Mar 2002 16:02:12 -0600
|
|
Well are you at the server where this is being hosted? Can you right
click the physical db and view the permissions for it?
You need to set permissions on it so the user that the web server is
passing has permissions to alter the db, ie My Server uses a generic
webuser account as the anonymous account, in any db I use I have to
allow that account to change things, using an access db I usually just
give "Everyone" permissions on it to save time, I do most of my asp with
sql server though. The concept is the same, just treat it like any old
file permission.
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 3:50 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
U know I am very green, so where can I find it?
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 1:45 PM
Subject: [asp_databases] RE: problem with insert data into database
> Hmm do oyu have control of the permissions for the database?
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 3:36 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> I changed it , but it still have the same problem..
> I am now using the Access 97 for my Database
> ----- Original Message -----
> From: "Patrick Sullivan" <pat@s...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, March 28, 2002 1:30 PM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> > What kind of database are we talking about?
> >
> > Seems to me that, if there is insufficient permissions on the db,
jet
> > should be returning something like "must use updatable query". Has
to
> be
> > the recordset - you may need to change that adOpenStatic to
> > adOpenForwardOnly....
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Thursday, March 28, 2002 3:24 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> > I checked my code , but I don't know what is the problem it
> >
> >
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only.
> > /schedule/addPAge.asp, line 18
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection")
objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist
Security
> > info=False"
> > Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable
> > objRS2.AddNew
> > objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Drew, Ron" <RDrew@B...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Wednesday, March 27, 2002 5:51 AM
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This is an example AddNew adds..no need to move to the last...check
> the
> > cursors on this one...example uses an autoID.
> >
> > objRS.Open
> >
>
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> > objRS.AddNew
> > objRS.Fields("column1") = strcolumn1
> > objRS.Fields("column2") = strcolumn2
> > objRS.Update
> > intID = objRS("appid")
> > Response.Write "<p>Record ID " & intID & " added!!</p>"
> >
> > objRS.Close
> > set objRS = Nothing
> > yourconnection.Close
> > set yourconnection = Nothing
> > set intID = Nothing
> >
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Wednesday, March 27, 2002 2:16 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This time the error is this :
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only.
/schedule/addPAge.asp,
> > line 18
> >
> > so what is that mean and how can I fix it
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection")
objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist
Security
> > info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable '
> > objRS2.MoveLast
> > objRS2.AddNew
> > objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
Message #17 by "Drew, Ron" <RDrew@B...> on Thu, 28 Mar 2002 17:09:36 -0500
|
|
OK..you changed the adOpenStatic to adOpenForwardOnly
1. go to the directory the MDB is in and right click, make sure it is
not readonly, click on security and give EVERYONE full control.
2. the example below has objRS2("EndDate") =3D "getEndDate" if
EndDate is a date, why are you setting it to the literal "getEndDate"?
Is getEndDate coming from a form? If so, objRS2("EndDate") =3D
request.form("getEndDate")
...If you did a request form to the literal getEndDate
getEndDate =3D request.form("myenddateonform")
objRS2("EndDate") =3D getEndDate
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 4:24 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I checked my code , but I don't know what is the problem it
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
<% option Explicit %>
<!-- # include file =3D "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 =3D Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Data
Source=3DC:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=3DFalse" Set objRS2 =3D Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable objRS2.AddNew objRS2("StartDate")=3D "getStartDate"
objRS2("EndDate") =3D "getEndDate"
objRS2("Content") =3D "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 =3D nothing
set objConn2 =3Dnothing
%>
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, March 27, 2002 5:51 AM
Subject: [asp_databases] RE: problem with insert data into database
This is an example AddNew adds..no need to move to the last...check the
cursors on this one...example uses an autoID.
objRS.Open
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
objRS.AddNew
objRS.Fields("column1") =3D strcolumn1
objRS.Fields("column2") =3D strcolumn2
objRS.Update
intID =3D objRS("appid")
Response.Write "<p>Record ID " & intID & " added!!</p>"
objRS.Close
set objRS =3D Nothing
yourconnection.Close
set yourconnection =3D Nothing
set intID =3D Nothing
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Wednesday, March 27, 2002 2:16 AM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file =3D "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 =3D Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Data
Source=3DC:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=3DFalse" Set objRS2 =3D Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")=3D "getStartDate"
objRS2("EndDate") =3D "getEndDate"
objRS2("Content") =3D "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 =3D nothing
set objConn2 =3Dnothing
%>
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #18 by "Derek" <derekwong600@h...> on Thu, 28 Mar 2002 14:27:24 -0800
|
|
I can't see any "security tap" but the I am sure that the readonly isn't
checked
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:09 PM
Subject: [asp_databases] RE: problem with insert data into database
OK..you changed the adOpenStatic to adOpenForwardOnly
1. go to the directory the MDB is in and right click, make sure it is
not readonly, click on security and give EVERYONE full control.
2. the example below has objRS2("EndDate") = "getEndDate" if
EndDate is a date, why are you setting it to the literal "getEndDate"?
Is getEndDate coming from a form? If so, objRS2("EndDate")
request.form("getEndDate")
...If you did a request form to the literal getEndDate
getEndDate = request.form("myenddateonform")
objRS2("EndDate") = getEndDate
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 4:24 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I checked my code , but I don't know what is the problem it
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, March 27, 2002 5:51 AM
Subject: [asp_databases] RE: problem with insert data into database
This is an example AddNew adds..no need to move to the last...check the
cursors on this one...example uses an autoID.
objRS.Open
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
objRS.AddNew
objRS.Fields("column1") = strcolumn1
objRS.Fields("column2") = strcolumn2
objRS.Update
intID = objRS("appid")
Response.Write "<p>Record ID " & intID & " added!!</p>"
objRS.Close
set objRS = Nothing
yourconnection.Close
set yourconnection = Nothing
set intID = Nothing
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Wednesday, March 27, 2002 2:16 AM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #19 by "Patrick Sullivan" <pat@s...> on Thu, 28 Mar 2002 16:36:09 -0600
|
|
Is the drive the mdb is on a Fat32 drive or ntfs?
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 4:27 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I can't see any "security tap" but the I am sure that the readonly isn't
checked
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:09 PM
Subject: [asp_databases] RE: problem with insert data into database
OK..you changed the adOpenStatic to adOpenForwardOnly
1. go to the directory the MDB is in and right click, make sure it is
not readonly, click on security and give EVERYONE full control.
2. the example below has objRS2("EndDate") = "getEndDate" if
EndDate is a date, why are you setting it to the literal "getEndDate"?
Is getEndDate coming from a form? If so, objRS2("EndDate")
request.form("getEndDate")
...If you did a request form to the literal getEndDate
getEndDate = request.form("myenddateonform")
objRS2("EndDate") = getEndDate
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 4:24 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I checked my code , but I don't know what is the problem it
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, March 27, 2002 5:51 AM
Subject: [asp_databases] RE: problem with insert data into database
This is an example AddNew adds..no need to move to the last...check the
cursors on this one...example uses an autoID.
objRS.Open
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
objRS.AddNew
objRS.Fields("column1") = strcolumn1
objRS.Fields("column2") = strcolumn2
objRS.Update
intID = objRS("appid")
Response.Write "<p>Record ID " & intID & " added!!</p>"
objRS.Close
set objRS = Nothing
yourconnection.Close
set yourconnection = Nothing
set intID = Nothing
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Wednesday, March 27, 2002 2:16 AM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #20 by "Drew, Ron" <RDrew@B...> on Thu, 28 Mar 2002 17:37:30 -0500
|
|
Sorry... go to the directory the MDB is in and right click, make sure
it is not readonly, click on properties and select the security tab
..pick EVERYONE and check the lower boxes for full control.
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 5:27 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I can't see any "security tap" but the I am sure that the readonly isn't
checked
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:09 PM
Subject: [asp_databases] RE: problem with insert data into database
OK..you changed the adOpenStatic to adOpenForwardOnly
1. go to the directory the MDB is in and right click, make sure it is
not readonly, click on security and give EVERYONE full control.
2. the example below has objRS2("EndDate") =3D "getEndDate" if
EndDate is a date, why are you setting it to the literal "getEndDate"?
Is getEndDate coming from a form? If so, objRS2("EndDate") =3D
request.form("getEndDate")
...If you did a request form to the literal getEndDate getEndDate =3D
request.form("myenddateonform")
objRS2("EndDate") =3D getEndDate
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 4:24 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I checked my code , but I don't know what is the problem it
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
<% option Explicit %>
<!-- # include file =3D "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 =3D Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Data
Source=3DC:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=3DFalse" Set objRS2 =3D Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable objRS2.AddNew objRS2("StartDate")=3D "getStartDate"
objRS2("EndDate") =3D "getEndDate"
objRS2("Content") =3D "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 =3D nothing
set objConn2 =3Dnothing
%>
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, March 27, 2002 5:51 AM
Subject: [asp_databases] RE: problem with insert data into database
This is an example AddNew adds..no need to move to the last...check the
cursors on this one...example uses an autoID.
objRS.Open
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
objRS.AddNew
objRS.Fields("column1") =3D strcolumn1
objRS.Fields("column2") =3D strcolumn2
objRS.Update
intID =3D objRS("appid")
Response.Write "<p>Record ID " & intID & " added!!</p>"
objRS.Close
set objRS =3D Nothing
yourconnection.Close
set yourconnection =3D Nothing
set intID =3D Nothing
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Wednesday, March 27, 2002 2:16 AM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file =3D "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 =3D Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Data
Source=3DC:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=3DFalse" Set objRS2 =3D Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")=3D "getStartDate"
objRS2("EndDate") =3D "getEndDate"
objRS2("Content") =3D "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 =3D nothing
set objConn2 =3Dnothing
%>
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #21 by "Derek" <derekwong600@h...> on Thu, 28 Mar 2002 14:48:36 -0800
|
|
I am now using the XP show there are some differences
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:37 PM
Subject: [asp_databases] RE: problem with insert data into database
Sorry... go to the directory the MDB is in and right click, make sure
it is not readonly, click on properties and select the security tab
..pick EVERYONE and check the lower boxes for full control.
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 5:27 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I can't see any "security tap" but the I am sure that the readonly isn't
checked
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:09 PM
Subject: [asp_databases] RE: problem with insert data into database
OK..you changed the adOpenStatic to adOpenForwardOnly
1. go to the directory the MDB is in and right click, make sure it is
not readonly, click on security and give EVERYONE full control.
2. the example below has objRS2("EndDate") = "getEndDate" if
EndDate is a date, why are you setting it to the literal "getEndDate"?
Is getEndDate coming from a form? If so, objRS2("EndDate")
request.form("getEndDate")
...If you did a request form to the literal getEndDate getEndDate
request.form("myenddateonform")
objRS2("EndDate") = getEndDate
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 4:24 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I checked my code , but I don't know what is the problem it
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, March 27, 2002 5:51 AM
Subject: [asp_databases] RE: problem with insert data into database
This is an example AddNew adds..no need to move to the last...check the
cursors on this one...example uses an autoID.
objRS.Open
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
objRS.AddNew
objRS.Fields("column1") = strcolumn1
objRS.Fields("column2") = strcolumn2
objRS.Update
intID = objRS("appid")
Response.Write "<p>Record ID " & intID & " added!!</p>"
objRS.Close
set objRS = Nothing
yourconnection.Close
set yourconnection = Nothing
set intID = Nothing
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Wednesday, March 27, 2002 2:16 AM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #22 by "Patrick Sullivan" <pat@s...> on Thu, 28 Mar 2002 16:52:49 -0600
|
|
Wiat you're using windows xp and office 97? That's a little off...just
seems curious,
You should still be able to view the properties for that database, and
in xp the right click is the same. If you can't view the "security tab"
I would say that you need to make sure the file system on the drive is
ntfs you can check this if you go to Administrative Tools/Computer
Management then expand the left side so you can view the Disk Manager,
should tell you what the file system is. You may even be able to see
that if you right click the drive and view its properties.
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 4:49 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I am now using the XP show there are some differences
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:37 PM
Subject: [asp_databases] RE: problem with insert data into database
Sorry... go to the directory the MDB is in and right click, make sure
it is not readonly, click on properties and select the security tab
..pick EVERYONE and check the lower boxes for full control.
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 5:27 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I can't see any "security tap" but the I am sure that the readonly isn't
checked
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:09 PM
Subject: [asp_databases] RE: problem with insert data into database
OK..you changed the adOpenStatic to adOpenForwardOnly
1. go to the directory the MDB is in and right click, make sure it is
not readonly, click on security and give EVERYONE full control.
2. the example below has objRS2("EndDate") = "getEndDate" if
EndDate is a date, why are you setting it to the literal "getEndDate"?
Is getEndDate coming from a form? If so, objRS2("EndDate")
request.form("getEndDate")
...If you did a request form to the literal getEndDate getEndDate
request.form("myenddateonform")
objRS2("EndDate") = getEndDate
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 4:24 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
I checked my code , but I don't know what is the problem it
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, March 27, 2002 5:51 AM
Subject: [asp_databases] RE: problem with insert data into database
This is an example AddNew adds..no need to move to the last...check the
cursors on this one...example uses an autoID.
objRS.Open
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
objRS.AddNew
objRS.Fields("column1") = strcolumn1
objRS.Fields("column2") = strcolumn2
objRS.Update
intID = objRS("appid")
Response.Write "<p>Record ID " & intID & " added!!</p>"
objRS.Close
set objRS = Nothing
yourconnection.Close
set yourconnection = Nothing
set intID = Nothing
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Wednesday, March 27, 2002 2:16 AM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
This time the error is this :
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only. /schedule/addPAge.asp,
line 18
so what is that mean and how can I fix it
<% option Explicit %>
<!-- # include file = "adobvs.inc"-->
<%
Dim objConn2,objRS2
set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
,adCmdTable '
objRS2.MoveLast
objRS2.AddNew
objRS2("StartDate")= "getStartDate"
objRS2("EndDate") = "getEndDate"
objRS2("Content") = "getContent"
objRS2.Update
objRS2.Close
objConn2.Close
set objRS2 = nothing
set objConn2 =nothing
%>
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
Message #23 by "Derek" <derekwong600@h...> on Thu, 28 Mar 2002 14:55:10 -0800
|
|
NTFS
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:36 PM
Subject: [asp_databases] RE: problem with insert data into database
> Is the drive the mdb is on a Fat32 drive or ntfs?
>
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 4:27 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> I can't see any "security tap" but the I am sure that the readonly isn't
> checked
>
>
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, March 28, 2002 2:09 PM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> OK..you changed the adOpenStatic to adOpenForwardOnly
> 1. go to the directory the MDB is in and right click, make sure it is
> not readonly, click on security and give EVERYONE full control.
>
> 2. the example below has objRS2("EndDate") = "getEndDate" if
> EndDate is a date, why are you setting it to the literal "getEndDate"?
> Is getEndDate coming from a form? If so, objRS2("EndDate")
> request.form("getEndDate")
>
> ...If you did a request form to the literal getEndDate
> getEndDate = request.form("myenddateonform")
> objRS2("EndDate") = getEndDate
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 4:24 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> I checked my code , but I don't know what is the problem it
>
>
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> line 18
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
>
>
>
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Wednesday, March 27, 2002 5:51 AM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This is an example AddNew adds..no need to move to the last...check the
> cursors on this one...example uses an autoID.
>
> objRS.Open
> "yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> objRS.AddNew
> objRS.Fields("column1") = strcolumn1
> objRS.Fields("column2") = strcolumn2
> objRS.Update
> intID = objRS("appid")
> Response.Write "<p>Record ID " & intID & " added!!</p>"
>
> objRS.Close
> set objRS = Nothing
> yourconnection.Close
> set yourconnection = Nothing
> set intID = Nothing
>
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Wednesday, March 27, 2002 2:16 AM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This time the error is this :
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> line 18
>
> so what is that mean and how can I fix it
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable '
> objRS2.MoveLast
> objRS2.AddNew
> objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>
>
>
>
>
>
>
>
>
Message #24 by "Derek" <derekwong600@h...> on Thu, 28 Mar 2002 15:01:15 -0800
|
|
I have check it , it is NTFS
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 2:52 PM
Subject: [asp_databases] RE: problem with insert data into database
> Wiat you're using windows xp and office 97? That's a little off...just
> seems curious,
>
> You should still be able to view the properties for that database, and
> in xp the right click is the same. If you can't view the "security tab"
> I would say that you need to make sure the file system on the drive is
> ntfs you can check this if you go to Administrative Tools/Computer
> Management then expand the left side so you can view the Disk Manager,
> should tell you what the file system is. You may even be able to see
> that if you right click the drive and view its properties.
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 4:49 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> I am now using the XP show there are some differences
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, March 28, 2002 2:37 PM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> Sorry... go to the directory the MDB is in and right click, make sure
> it is not readonly, click on properties and select the security tab
> ..pick EVERYONE and check the lower boxes for full control.
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 5:27 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> I can't see any "security tap" but the I am sure that the readonly isn't
> checked
>
>
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, March 28, 2002 2:09 PM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> OK..you changed the adOpenStatic to adOpenForwardOnly
> 1. go to the directory the MDB is in and right click, make sure it is
> not readonly, click on security and give EVERYONE full control.
>
> 2. the example below has objRS2("EndDate") = "getEndDate" if
> EndDate is a date, why are you setting it to the literal "getEndDate"?
> Is getEndDate coming from a form? If so, objRS2("EndDate")
> request.form("getEndDate")
>
> ...If you did a request form to the literal getEndDate getEndDate
> request.form("myenddateonform")
> objRS2("EndDate") = getEndDate
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 4:24 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> I checked my code , but I don't know what is the problem it
>
>
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> line 18
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
>
>
>
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Wednesday, March 27, 2002 5:51 AM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This is an example AddNew adds..no need to move to the last...check the
> cursors on this one...example uses an autoID.
>
> objRS.Open
> "yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> objRS.AddNew
> objRS.Fields("column1") = strcolumn1
> objRS.Fields("column2") = strcolumn2
> objRS.Update
> intID = objRS("appid")
> Response.Write "<p>Record ID " & intID & " added!!</p>"
>
> objRS.Close
> set objRS = Nothing
> yourconnection.Close
> set yourconnection = Nothing
> set intID = Nothing
>
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Wednesday, March 27, 2002 2:16 AM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> This time the error is this :
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> line 18
>
> so what is that mean and how can I fix it
>
> <% option Explicit %>
> <!-- # include file = "adobvs.inc"-->
>
> <%
> Dim objConn2,objRS2
> set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> ,adCmdTable '
> objRS2.MoveLast
> objRS2.AddNew
> objRS2("StartDate")= "getStartDate"
> objRS2("EndDate") = "getEndDate"
> objRS2("Content") = "getContent"
> objRS2.Update
> objRS2.Close
> objConn2.Close
> set objRS2 = nothing
> set objConn2 =nothing
> %>
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>
>
>
>
>
>
>
>
>
Message #25 by "Derek" <derekwong600@h...> on Thu, 28 Mar 2002 15:20:50 -0800
|
|
when I point to the db and then right click , then I select propert .
I can only see the (general and summary ) tabs but I can't see and security
tab
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 3:02 PM
Subject: [asp_databases] RE: problem with insert data into database
> Hmm then it should be there...can't really think of anything else, when
> you right click the mdb you should see a series of Tabs at the top of
> the properties window (General, Security, Summary) click the security
> tab and that's where you need to change things, also make sure you have
> the db open in shared mode, not exclusive mode, you can see this in the
> access db by clicking tools/options then going to the advanced tab.
>
> If none of that works I am at a loss.
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 4:55 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> NTFS
> ----- Original Message -----
> From: "Patrick Sullivan" <pat@s...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, March 28, 2002 2:36 PM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> > Is the drive the mdb is on a Fat32 drive or ntfs?
> >
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Thursday, March 28, 2002 4:27 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> > I can't see any "security tap" but the I am sure that the readonly
> isn't
> > checked
> >
> >
> > ----- Original Message -----
> > From: "Drew, Ron" <RDrew@B...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Thursday, March 28, 2002 2:09 PM
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > OK..you changed the adOpenStatic to adOpenForwardOnly
> > 1. go to the directory the MDB is in and right click, make sure it is
> > not readonly, click on security and give EVERYONE full control.
> >
> > 2. the example below has objRS2("EndDate") = "getEndDate" if
> > EndDate is a date, why are you setting it to the literal "getEndDate"?
> > Is getEndDate coming from a form? If so, objRS2("EndDate")
> > request.form("getEndDate")
> >
> > ...If you did a request form to the literal getEndDate
> > getEndDate = request.form("myenddateonform")
> > objRS2("EndDate") = getEndDate
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Thursday, March 28, 2002 4:24 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > I checked my code , but I don't know what is the problem it
> >
> >
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> > line 18
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> > info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Drew, Ron" <RDrew@B...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Wednesday, March 27, 2002 5:51 AM
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This is an example AddNew adds..no need to move to the last...check
> the
> > cursors on this one...example uses an autoID.
> >
> > objRS.Open
> >
> "yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> > objRS.AddNew
> > objRS.Fields("column1") = strcolumn1
> > objRS.Fields("column2") = strcolumn2
> > objRS.Update
> > intID = objRS("appid")
> > Response.Write "<p>Record ID " & intID & " added!!</p>"
> >
> > objRS.Close
> > set objRS = Nothing
> > yourconnection.Close
> > set yourconnection = Nothing
> > set intID = Nothing
> >
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Wednesday, March 27, 2002 2:16 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This time the error is this :
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> > line 18
> >
> > so what is that mean and how can I fix it
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> > info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable '
> > objRS2.MoveLast
> > objRS2.AddNew
> > objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> > ---
> > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > unsubscribe send a blank email to
> >
> > ---
> > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > unsubscribe send a blank email to
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
Message #26 by "Derek" <derekwong600@h...> on Thu, 28 Mar 2002 15:34:02 -0800
|
|
would u mind to check it for for if I send my page and the database to u
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 3:02 PM
Subject: [asp_databases] RE: problem with insert data into database
> Hmm then it should be there...can't really think of anything else, when
> you right click the mdb you should see a series of Tabs at the top of
> the properties window (General, Security, Summary) click the security
> tab and that's where you need to change things, also make sure you have
> the db open in shared mode, not exclusive mode, you can see this in the
> access db by clicking tools/options then going to the advanced tab.
>
> If none of that works I am at a loss.
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 4:55 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> NTFS
> ----- Original Message -----
> From: "Patrick Sullivan" <pat@s...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, March 28, 2002 2:36 PM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> > Is the drive the mdb is on a Fat32 drive or ntfs?
> >
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Thursday, March 28, 2002 4:27 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> > I can't see any "security tap" but the I am sure that the readonly
> isn't
> > checked
> >
> >
> > ----- Original Message -----
> > From: "Drew, Ron" <RDrew@B...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Thursday, March 28, 2002 2:09 PM
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > OK..you changed the adOpenStatic to adOpenForwardOnly
> > 1. go to the directory the MDB is in and right click, make sure it is
> > not readonly, click on security and give EVERYONE full control.
> >
> > 2. the example below has objRS2("EndDate") = "getEndDate" if
> > EndDate is a date, why are you setting it to the literal "getEndDate"?
> > Is getEndDate coming from a form? If so, objRS2("EndDate")
> > request.form("getEndDate")
> >
> > ...If you did a request form to the literal getEndDate
> > getEndDate = request.form("myenddateonform")
> > objRS2("EndDate") = getEndDate
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Thursday, March 28, 2002 4:24 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > I checked my code , but I don't know what is the problem it
> >
> >
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> > line 18
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> > info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Drew, Ron" <RDrew@B...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Wednesday, March 27, 2002 5:51 AM
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This is an example AddNew adds..no need to move to the last...check
> the
> > cursors on this one...example uses an autoID.
> >
> > objRS.Open
> >
> "yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> > objRS.AddNew
> > objRS.Fields("column1") = strcolumn1
> > objRS.Fields("column2") = strcolumn2
> > objRS.Update
> > intID = objRS("appid")
> > Response.Write "<p>Record ID " & intID & " added!!</p>"
> >
> > objRS.Close
> > set objRS = Nothing
> > yourconnection.Close
> > set yourconnection = Nothing
> > set intID = Nothing
> >
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Wednesday, March 27, 2002 2:16 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This time the error is this :
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only. /schedule/addPAge.asp,
> > line 18
> >
> > so what is that mean and how can I fix it
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection") objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist Security
> > info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable '
> > objRS2.MoveLast
> > objRS2.AddNew
> > objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> > ---
> > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > unsubscribe send a blank email to
> >
> > ---
> > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > unsubscribe send a blank email to
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
Message #27 by "Patrick Sullivan" <pat@s...> on Fri, 29 Mar 2002 15:00:15 -0600
|
|
Sounds like you don't have administrative privileges on your computer
there now. Not sure what else it could be.
-----Original Message-----
From: Derek [mailto:derekwong600@h...]
Sent: Thursday, March 28, 2002 5:21 PM
To: ASP Databases
Subject: [asp_databases] RE: problem with insert data into database
when I point to the db and then right click , then I select propert .
I can only see the (general and summary ) tabs but I can't see and
security
tab
----- Original Message -----
From: "Patrick Sullivan" <pat@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, March 28, 2002 3:02 PM
Subject: [asp_databases] RE: problem with insert data into database
> Hmm then it should be there...can't really think of anything else,
when
> you right click the mdb you should see a series of Tabs at the top of
> the properties window (General, Security, Summary) click the security
> tab and that's where you need to change things, also make sure you
have
> the db open in shared mode, not exclusive mode, you can see this in
the
> access db by clicking tools/options then going to the advanced tab.
>
> If none of that works I am at a loss.
>
> -----Original Message-----
> From: Derek [mailto:derekwong600@h...]
> Sent: Thursday, March 28, 2002 4:55 PM
> To: ASP Databases
> Subject: [asp_databases] RE: problem with insert data into database
>
> NTFS
> ----- Original Message -----
> From: "Patrick Sullivan" <pat@s...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, March 28, 2002 2:36 PM
> Subject: [asp_databases] RE: problem with insert data into database
>
>
> > Is the drive the mdb is on a Fat32 drive or ntfs?
> >
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Thursday, March 28, 2002 4:27 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> > I can't see any "security tap" but the I am sure that the readonly
> isn't
> > checked
> >
> >
> > ----- Original Message -----
> > From: "Drew, Ron" <RDrew@B...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Thursday, March 28, 2002 2:09 PM
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > OK..you changed the adOpenStatic to adOpenForwardOnly
> > 1. go to the directory the MDB is in and right click, make sure it
is
> > not readonly, click on security and give EVERYONE full control.
> >
> > 2. the example below has objRS2("EndDate") = "getEndDate" if
> > EndDate is a date, why are you setting it to the literal
"getEndDate"?
> > Is getEndDate coming from a form? If so, objRS2("EndDate")
> > request.form("getEndDate")
> >
> > ...If you did a request form to the literal getEndDate
> > getEndDate = request.form("myenddateonform")
> > objRS2("EndDate") = getEndDate
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Thursday, March 28, 2002 4:24 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > I checked my code , but I don't know what is the problem it
> >
> >
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only.
/schedule/addPAge.asp,
> > line 18
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection")
objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist
Security
> > info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable objRS2.AddNew objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Drew, Ron" <RDrew@B...>
> > To: "ASP Databases" <asp_databases@p...>
> > Sent: Wednesday, March 27, 2002 5:51 AM
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This is an example AddNew adds..no need to move to the last...check
> the
> > cursors on this one...example uses an autoID.
> >
> > objRS.Open
> >
>
"yourtable",yourconnection,adOpenForwardOnly,adLockOptimistic,adCmdTable
> > objRS.AddNew
> > objRS.Fields("column1") = strcolumn1
> > objRS.Fields("column2") = strcolumn2
> > objRS.Update
> > intID = objRS("appid")
> > Response.Write "<p>Record ID " & intID & " added!!</p>"
> >
> > objRS.Close
> > set objRS = Nothing
> > yourconnection.Close
> > set yourconnection = Nothing
> > set intID = Nothing
> >
> >
> > -----Original Message-----
> > From: Derek [mailto:derekwong600@h...]
> > Sent: Wednesday, March 27, 2002 2:16 AM
> > To: ASP Databases
> > Subject: [asp_databases] RE: problem with insert data into database
> >
> >
> > This time the error is this :
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only.
/schedule/addPAge.asp,
> > line 18
> >
> > so what is that mean and how can I fix it
> >
> > <% option Explicit %>
> > <!-- # include file = "adobvs.inc"-->
> >
> > <%
> > Dim objConn2,objRS2
> > set objConn2 = Server.CreateObject ("ADODB.Connection")
objConn2.Open
> > "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=C:\Hello\Schedule\Schedule_Local\DateBase.mdb;Persist
Security
> > info=False" Set objRS2 = Server.CreateObject ("ADODB.Recordset")
> > objRS2.Open "adminContent", objConn2, adOpenStatic ,adLockOptimistic
> > ,adCmdTable '
> > objRS2.MoveLast
> > objRS2.AddNew
> > objRS2("StartDate")= "getStartDate"
> > objRS2("EndDate") = "getEndDate"
> > objRS2("Content") = "getContent"
> > objRS2.Update
> > objRS2.Close
> > objConn2.Close
> > set objRS2 = nothing
> > set objConn2 =nothing
> > %>
> >
> >
> > ---
> > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > unsubscribe send a blank email to
> >
> > ---
> > Change your mail options at http://p2p.wrox.com/manager.asp or to
> > unsubscribe send a blank email to
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
| |
View Cart
