|
 |
asp_databases thread: Operation must use an updateable query.
Message #1 by "Thorton K. Burfine" <tburfine@k...> on Tue, 17 Apr 2001 21:03:51 -0500
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0025_01C0C781.E76DDF60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Database:
Access 97 or 2000 (tried both)
Server:
Windows 2000 Advance Server
MDAC:
2.6
Access 2000 is installed on the server.
CODE:
(included file fo the connection does work and returns records)
dim strSQL
strSQL=3Drequest.form("txtINSERT")
Session("UserID")=3DRequest.Form("txtLogIn")
Response.Write strSQL
myConnection.execute strSQL,,1
if err.number<>0 then
Response.Write "<BR>" & err.number & "<BR>" & err.description
end if
set myConnection=3Dnothing
Response.Redirect "Step1.asp"
What is returned:
insert into tblUsers (uName, uLogIn, uPWD, uEmailAddy, uURL) values('h',
'h', 'h', 'h', 'h')
-2147467259
Operation must use an updateable query.
The code and script runs on NT4 sp4 and NT4 sp6a both with MDAC 2.1
Will not run on Win2K Adv. Server?
Any clues?
Message #2 by "Thor Burfine" <tburfine@k...> on Wed, 18 Apr 2001 23:10:28
|
|
RESOLVED...
the NT user IEUSER_MachineName must have write permissions to the folder
the DB is in.
Thor
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0025_01C0C781.E76DDF60
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Database:
> Access 97 or 2000 (tried both)
> Server:
> Windows 2000 Advance Server
> MDAC:
> 2.6
> Access 2000 is installed on the server.
>
> CODE:
> (included file fo the connection does work and returns records)
> dim strSQL
> strSQL=3Drequest.form("txtINSERT")
> Session("UserID")=3DRequest.Form("txtLogIn")
> Response.Write strSQL
> myConnection.execute strSQL,,1
> if err.number<>0 then
> Response.Write "<BR>" & err.number & "<BR>" & err.description
> end if
> set myConnection=3Dnothing
> Response.Redirect "Step1.asp"
>
> What is returned:
> insert into tblUsers (uName, uLogIn, uPWD, uEmailAddy, uURL) values('h',
> 'h', 'h', 'h', 'h')
> -2147467259
> Operation must use an updateable query.
>
>
>
> The code and script runs on NT4 sp4 and NT4 sp6a both with MDAC 2.1
> Will not run on Win2K Adv. Server?
>
> Any clues?
>
>
> ------=_NextPart_000_0025_01C0C781.E76DDF60
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1"
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Database:<BR> Access
> 97 or 2000
> (tried both)<BR>Server:<BR> Windows 2000 Advance
> Server<BR>MDAC:<BR> 2.6<BR>Access 2000 is installed on
> the
> server.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>CODE:<BR>(included file fo the
> connection does work
> and returns records)<BR> dim
> strSQL<BR> strSQL=3Drequest.form("txtINSERT")<BR> Session
("User
> ID")=3DRequest.Form("txtLogIn")<BR> Response.Write
> strSQL<BR> myConnection.execute strSQL,,1<BR> if
> err.number<>0
> then<BR> Response.Write "<BR>" & err.number &
> "<BR>" & err.description<BR> end if<BR> set
> myConnection=3Dnothing<BR> Response.Redirect
> "Step1.asp"</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>What is returned:<BR>insert into
> tblUsers (uName,
> uLogIn, uPWD, uEmailAddy, uURL) values('h', 'h', 'h', 'h',
> 'h')<BR>-2147467259<BR>Operation must use an updateable
> query.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>The code and script runs on NT4 sp4 and
> NT4 sp6a
> both with MDAC 2.1<BR>Will not run on Win2K Adv. Server?</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Any
> clues?<BR></FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_0025_01C0C781.E76DDF60--
>
Message #3 by Craig Flannigan <ckf@k...> on Thu, 19 Apr 01 08:10:41 BST
|
|
It's a problem with the File Rights on your .mdb file.
Ensure that your Internet Guest Account, !USR_Machinename account
has Read and Change/Write properties selected. All the error means
is that it is not allowed to perform the function on the mdb file as
NT won't allow it.
Hope this has helped.
Regards,
Craig.
_____________________________________________________
Craig Flannigan
Development Supervisor - Business Systems
Kaye House
Tel: 0114 256 6070
Email: ckf@k...
----------
>Database:
> Access 97 or 2000 (tried both)
>Server:
> Windows 2000 Advance Server
>MDAC:
> 2.6
>Access 2000 is installed on the server.
>
>CODE:
>(included file fo the connection does work and returns records)
> dim strSQL
> strSQL=request.form("txtINSERT")
> Session("UserID")=Request.Form("txtLogIn")
> Response.Write strSQL
> myConnection.execute strSQL,,1
> if err.number<>0 then
> Response.Write "<BR>" & err.number & "<BR>" & err.description
> end if
> set myConnection=nothing
> Response.Redirect "Step1.asp"
>
>What is returned:
>insert into tblUsers (uName, uLogIn, uPWD, uEmailAddy, uURL)
>values('h', 'h', 'h', 'h', 'h')
>-2147467259
>Operation must use an updateable query.
>
>
>
>The code and script runs on NT4 sp4 and NT4 sp6a both with MDAC
>2.1
>Will not run on Win2K Adv. Server?
>
>Any clues?
>
>
>
|
|
|
View Cart
