|
 |
asp_databases thread: Operation must use an updateable query.
Message #1 by "Medhat Wahba" <wahba@p...> on Mon, 29 Jan 2001 17:24:11 -0000
|
|
I hope you can help with this problem
I get this message when running on IIS
INSERT INTO Students (CourseKey, EmployeeKey, Notes,
CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
Medhat Wahba',#01/01/01#)
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/tdb1/writeRequest.asp, line 43
Line 43 is "Set objXXX = objConn.Execute(sSQL)"
and I write the sSQL string; it is shown write before the error message.
"INSERT INTO Students (CourseKey, EmployeeKey, Notes,
CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
Medhat Wahba',#01/01/01#) "
I will appreciate all the help I can get. It may be a problem with the
server installation, any ideas?
Message #2 by =?iso-8859-1?Q?H=E5kan_Frennesson?= <hakan@c...> on Mon, 29 Jan 2001 18:53:11 +0100
|
|
Hi!
It is a file/folder permission problem. Make sure the IUSER<computername>
account has read and write permissions on the database and read, write and
delete permissions on the folder where the database resides. I am sure this
will solve the problem.
Hakan
-----Original Message-----
From: Medhat Wahba [mailto:wahba@p...]
Sent: den 29 januari 2001 18:24
To: ASP Databases
Subject: [asp_databases] Operation must use an updateable query.
I hope you can help with this problem
I get this message when running on IIS
INSERT INTO Students (CourseKey, EmployeeKey, Notes,
CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
Medhat Wahba',#01/01/01#)
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/tdb1/writeRequest.asp, line 43
Line 43 is "Set objXXX = objConn.Execute(sSQL)"
and I write the sSQL string; it is shown write before the error message.
"INSERT INTO Students (CourseKey, EmployeeKey, Notes,
CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
Medhat Wahba',#01/01/01#) "
I will appreciate all the help I can get. It may be a problem with the
server installation, any ideas?
Message #3 by "Xu Gary" <Gary.Xu@p...> on Mon, 29 Jan 2001 13:52:49 -0800
|
|
What kind of connection/recordset do you open? Is it adReadOnly or some
other not "updateable" type?
-----Original Message-----
From: Medhat Wahba [mailto:wahba@p...]
Sent: Monday, January 29, 2001 9:24 AM
To: ASP Databases
Subject: [asp_databases] Operation must use an updateable query.
I hope you can help with this problem
I get this message when running on IIS
INSERT INTO Students (CourseKey, EmployeeKey, Notes,
CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
Medhat Wahba',#01/01/01#)
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/tdb1/writeRequest.asp, line 43
Line 43 is "Set objXXX = objConn.Execute(sSQL)"
and I write the sSQL string; it is shown write before the error message.
"INSERT INTO Students (CourseKey, EmployeeKey, Notes,
CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
Medhat Wahba',#01/01/01#) "
I will appreciate all the help I can get. It may be a problem with the
server installation, any ideas?
Message #4 by John Pirkey <mailjohnny101@y...> on Mon, 29 Jan 2001 14:48:28 -0800 (PST)
|
|
the INSERT statement will not return a recordset - so why try and grab one?
instead, try
objConn.Execute sSQL
although, it should've worked before, but the recordset would have been closed, but
access might be a little funny about that (it wouldn't be the first time it was
"funny").
john
--- Xu Gary <Gary.Xu@p...> wrote:
> What kind of connection/recordset do you open? Is it adReadOnly or some
> other not "updateable" type?
>
>
>
>
> -----Original Message-----
> From: Medhat Wahba [mailto:wahba@p...]
> Sent: Monday, January 29, 2001 9:24 AM
> To: ASP Databases
> Subject: [asp_databases] Operation must use an updateable query.
>
>
> I hope you can help with this problem
>
> I get this message when running on IIS
>
>
> INSERT INTO Students (CourseKey, EmployeeKey, Notes,
> CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
> Medhat Wahba',#01/01/01#)
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> query.
>
> /tdb1/writeRequest.asp, line 43
>
>
> Line 43 is "Set objXXX = objConn.Execute(sSQL)"
>
> and I write the sSQL string; it is shown write before the error message.
> "INSERT INTO Students (CourseKey, EmployeeKey, Notes,
> CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
> Medhat Wahba',#01/01/01#) "
>
> I will appreciate all the help I can get. It may be a problem with the
> server installation, any ideas?
>
John Pirkey
MCSD
John@S...
http://www.stlvbug.org
Message #5 by "Wally Burfine" <oopconsultant@h...> on Tue, 30 Jan 2001 03:15:08 -0000
|
|
are you sure that students is a table and not a view?
>From: "Xu Gary" <Gary.Xu@p...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] RE: Operation must use an updateable query.
>Date: Mon, 29 Jan 2001 13:52:49 -0800
>
>What kind of connection/recordset do you open? Is it adReadOnly or some
>other not "updateable" type?
>
>
>
>
>-----Original Message-----
>From: Medhat Wahba [mailto:wahba@p...]
>Sent: Monday, January 29, 2001 9:24 AM
>To: ASP Databases
>Subject: [asp_databases] Operation must use an updateable query.
>
>
>I hope you can help with this problem
>
>I get this message when running on IIS
>
>
>INSERT INTO Students (CourseKey, EmployeeKey, Notes,
>CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
>Medhat Wahba',#01/01/01#)
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
>query.
>
>/tdb1/writeRequest.asp, line 43
>
>
>Line 43 is "Set objXXX = objConn.Execute(sSQL)"
>
>and I write the sSQL string; it is shown write before the error message.
>"INSERT INTO Students (CourseKey, EmployeeKey, Notes,
>CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
>Medhat Wahba',#01/01/01#) "
>
>I will appreciate all the help I can get. It may be a problem with the
>server installation, any ideas?
>
Message #6 by "Medhat Wahba" <wahba@p...> on Tue, 30 Jan 2001 19:42:18 -0000
|
|
Thanks for your help,
I tried objConn.Excute sSQL
received the same error?
protection seems to be ok.
The code runs on an NT workstation, using Apache Server.
Thanks,
> the INSERT statement will not return a recordset - so why try and grab one?
> instead, try
>
> objConn.Execute sSQL
>
> although, it should've worked before, but the recordset would have been closed, but
> access might be a little funny about that (it wouldn't be the first time it was
> "funny").
>
> john
>
>
> --- Xu Gary <Gary.Xu@p...> wrote:
> > What kind of connection/recordset do you open? Is it adReadOnly or some
> > other not "updateable" type?
> >
> >
> >
> >
> > -----Original Message-----
> > From: Medhat Wahba [mailto:wahba@p...]
> > Sent: Monday, January 29, 2001 9:24 AM
> > To: ASP Databases
> > Subject: [asp_databases] Operation must use an updateable query.
> >
> >
> > I hope you can help with this problem
> >
> > I get this message when running on IIS
> >
> >
> > INSERT INTO Students (CourseKey, EmployeeKey, Notes,
> > CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
> > Medhat Wahba',#01/01/01#)
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >
> > [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> > query.
> >
> > /tdb1/writeRequest.asp, line 43
> >
> >
> > Line 43 is "Set objXXX = objConn.Execute(sSQL)"
> >
> > and I write the sSQL string; it is shown write before the error message.
> > "INSERT INTO Students (CourseKey, EmployeeKey, Notes,
> > CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
> > Medhat Wahba',#01/01/01#) "
> >
> > I will appreciate all the help I can get. It may be a problem with the
> > server installation, any ideas?
> >
>
> John Pirkey
> MCSD
> John@S...
> http://www.stlvbug.org
Message #7 by =?iso-8859-1?Q?H=E5kan_Frennesson?= <hakan@c...> on Tue, 30 Jan 2001 22:52:25 +0100
|
|
Hi!
Did you check the file/folder NTFS permissions?
Hakan
-----Original Message-----
From: Medhat Wahba [mailto:wahba@p...]
Sent: den 30 januari 2001 20:42
To: ASP Databases
Subject: [asp_databases] RE: Operation must use an updateable query.
Thanks for your help,
I tried objConn.Excute sSQL
received the same error?
protection seems to be ok.
The code runs on an NT workstation, using Apache Server.
Thanks,
> the INSERT statement will not return a recordset - so why try and grab
one?
> instead, try
>
> objConn.Execute sSQL
>
> although, it should've worked before, but the recordset would have been
closed, but
> access might be a little funny about that (it wouldn't be the first time
it was
> "funny").
>
> john
>
>
> --- Xu Gary <Gary.Xu@p...> wrote:
> > What kind of connection/recordset do you open? Is it adReadOnly or some
> > other not "updateable" type?
> >
> >
> >
> >
> > -----Original Message-----
> > From: Medhat Wahba [mailto:wahba@p...]
> > Sent: Monday, January 29, 2001 9:24 AM
> > To: ASP Databases
> > Subject: [asp_databases] Operation must use an updateable query.
> >
> >
> > I hope you can help with this problem
> >
> > I get this message when running on IIS
> >
> >
> > INSERT INTO Students (CourseKey, EmployeeKey, Notes,
> > CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
> > Medhat Wahba',#01/01/01#)
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >
> > [Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable
> > query.
> >
> > /tdb1/writeRequest.asp, line 43
> >
> >
> > Line 43 is "Set objXXX = objConn.Execute(sSQL)"
> >
> > and I write the sSQL string; it is shown write before the error message.
> > "INSERT INTO Students (CourseKey, EmployeeKey, Notes,
> > CourseCompletionGoalDate) VALUES (1,2102,'Web Application: requested by
> > Medhat Wahba',#01/01/01#) "
> >
> > I will appreciate all the help I can get. It may be a problem with the
> > server installation, any ideas?
> >
>
> John Pirkey
> MCSD
> John@S...
> http://www.stlvbug.org
|
|
|
View Cart
