473,490 Members | 2,495 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

problem running code...

Hi!

I have a problem running my code on 2000 server and iis5.0.

The code runs perfectly on my localhost (xp iis5.1) but when i run it on
2000 server iis5.0 I get this error:

--------------------------------------

operation must use an updateable query

execute_insert_text_content.asp l 83
--------------------------------------

My code looks like this:
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''

<%@ LANGUAGE=JScript %>
<% Session.LCID = 1044 %>
<OBJECT id=cn PROGID="ADODB.Connection" RUNAT="server"></OBJECT>
<OBJECT id=rst PROGID="ADODB.Recordset" RUNAT="server"></OBJECT>
<OBJECT id=cm PROGID="ADODB.Command" RUNAT="server"></OBJECT>

<!--#include file="./library/utils.inc"-->
<!--#include file="./library/adojavas.inc"-->
<!--#include file="./library/db.inc"-->

<%
Response.Buffer = true;

CheckUser(Application("UserLevel"));

var sSQL = "";

var iNodeId = FormGetInteger("iNodeId", -1);
var iLanguageId = FormGetInteger("oComboLanguageId", -1);
var iListId = FormGetInteger("iListId", -1);
var strContentTitle = Request.Form("oEditContentTitle").Count > 0
? Request.Form("oEditContentTitle").Item(1) : "";
var strContentSubTitle = Request.Form("oEditContentSubTitle").Count
0 ? Request.Form("oEditContentSubTitle").Item(1) : ""; var strContentImage1 = Request.Form("oEditContentImage1").Count >
0 ? Request.Form("oEditContentImage1").Item(1) : "";
var strContentImage2 = Request.Form("oEditContentImage2").Count >
0 ? Request.Form("oEditContentImage2").Item(1) : "";
var strDocumentLink = Request.Form("oEditDocumentLink").Count > 0
? Request.Form("oEditDocumentLink").Item(1) : "";
var strDocumentLinkDescription =
Request.Form("oEditDocumentLinkDescription").Count > 0 ?
Request.Form("oEditDocumentLinkDescription").Item( 1) : "";
var strContentBody = Request.Form("oTextAreaContentBody").Count 0 ? Request.Form("oTextAreaContentBody").Item(1) : "";

var bMoreContents = FormGetInteger("iMoreContents", 0) == 1 ?
true : false;
var Fil1 = Request.Form("Fil1").Count > 0 ?
Request.Form("Fil1").Item(1) : "";
var Fil2 = Request.Form("Fil2").Count > 0 ?
Request.Form("Fil2").Item(1) : "";
var Fil3 = Request.Form("Fil3").Count > 0 ?
Request.Form("Fil3").Item(1) : "";
var Fil4 = Request.Form("Fil4").Count > 0 ?
Request.Form("Fil4").Item(1) : "";

if((iNodeId == -1) || (iLanguageId == -1) || (iListId == -1))
Response.Redirect("./tree_cms.asp");

cn.Open(Application("ADOConnectionString"));

cm.ActiveConnection = cn;

sSQL = "SELECT content_id FROM Content_Text WHERE topic_id=" + iNodeId;
sSQL += " AND language_id=" + iLanguageId + " AND list_id=" + iListId + "
AND preview=0";

rst.Open(sSQL, cn);

if(!rst.EOF)
{
// Update
cm.CommandText = "UPDATE Content_Text SET title = ?, sub_title = ?, body =
?, picture_file_name_1 = ?, ";
cm.CommandText += "picture_file_name_2 = ?, Fil1 = ?, Fil2 = ?, Fil3 = ?,
Fil4 = ?, document_link = ?, document_link_description = ?,";
cm.CommandText += "modification_date = " + GetActualDbDate() + ", user_name
= ? WHERE content_id=?";
cm.Parameters.Append(cm.CreateParameter("title", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("sub_title ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("body", adLongVarWChar,
adParamInput, 20480000));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_1", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_2", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil1", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("Fil2", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("Fil3", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("Fil4", adVarChar, adParamInput,
255));
cm.Parameters.Append(cm.CreateParameter("document_ link", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link_description",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("user_name ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("content_i d", adInteger,
adParamInput));
cm("title") = CutString(strContentTitle, 255);
cm("sub_title") = CutString(strContentSubTitle, 255);
cm("body") = strContentBody;
cm("picture_file_name_1") = CutString(strContentImage1, 255);
cm("picture_file_name_2") = CutString(strContentImage2, 255);
cm("Fil1") = CutString(Fil1, 255);
cm("Fil2") = CutString(Fil2, 255);
cm("Fil3") = CutString(Fil3, 255);
cm("Fil4") = CutString(Fil4, 255);
cm("document_link") = CutString(strDocumentLink, 255);
cm("document_link_description") = CutString(strDocumentLinkDescription,
255);
cm("user_name") = Session("UserName");
cm("content_id") = rst("content_id").value;
83 cm.Execute();
}
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''
line 83: cm.Execute();

Why does i work on my xp, but not on the 2000 server??????

I have also uploaded my code to another server, and it worked perfectly
there also..

Is there maby some options in iis that are set wrong???
Thanks!

Christopher Brandsdal

Jul 19 '05 #1
7 2203
This is an NTFS permissions problem. Give the IUSR_<machinename> account (or
whatever user context you are using) Read/Write permissions to the folder
(and files) where the .mdb file is, and also to the Windows temp directory.

Cheers
Ken
"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...
: Hi!
:
: I have a problem running my code on 2000 server and iis5.0.
:
: The code runs perfectly on my localhost (xp iis5.1) but when i run it on
: 2000 server iis5.0 I get this error:
:
: --------------------------------------
:
: operation must use an updateable query
:
: execute_insert_text_content.asp l 83
: --------------------------------------
:
: My code looks like this:
:
<snip>
Jul 19 '05 #2
hmm.. I have done this...
But it still won't work!
I think something else must be the problem..

"Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
news:Op**************@TK2MSFTNGP09.phx.gbl...
This is an NTFS permissions problem. Give the IUSR_<machinename> account (or whatever user context you are using) Read/Write permissions to the folder
(and files) where the .mdb file is, and also to the Windows temp directory.
Cheers
Ken
"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...
: Hi!
:
: I have a problem running my code on 2000 server and iis5.0.
:
: The code runs perfectly on my localhost (xp iis5.1) but when i run it on
: 2000 server iis5.0 I get this error:
:
: --------------------------------------
:
: operation must use an updateable query
:
: execute_insert_text_content.asp l 83
: --------------------------------------
:
: My code looks like this:
:
<snip>

Jul 19 '05 #3
Assuming this is an Access database (why wouldn't you think this information
was relevant? Always tell us the type and version of database you are using
when asking a database-related question - we are not looking over your
shoulder <grin>) I agree with Ken that this is a permissions issue. See
these articles:
http://www.aspfaq.com/show.asp?id=2062 - updatable cursor
http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

Depending on where this query is being run (in a regular page, or in the
session_onend event in global.asa), you need to give folder-level Change
permissions to both the IUSR and IWAM accounts for the folder containing the
database. Do not assume these accounts are in the Everyone group (they're
not).

Also, if the database is on a remote machine, the account used to access
that database must be a domain-level account:
http://support.microsoft.com/default...b;EN-US;253580
Finally, there is a slight possibility that the query itself is at fault, so
you should response.write the CommandText and see if it's a runnable query.

HTH,
Bob Barrows
Christopher Brandsdal wrote:
Hi!

I have a problem running my code on 2000 server and iis5.0.

The code runs perfectly on my localhost (xp iis5.1) but when i run it
on 2000 server iis5.0 I get this error:

--------------------------------------

operation must use an updateable query

execute_insert_text_content.asp l 83
--------------------------------------

My code looks like this:
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''

<%@ LANGUAGE=JScript %>
<% Session.LCID = 1044 %>
<OBJECT id=cn PROGID="ADODB.Connection" RUNAT="server"></OBJECT>
<OBJECT id=rst PROGID="ADODB.Recordset" RUNAT="server"></OBJECT>
<OBJECT id=cm PROGID="ADODB.Command" RUNAT="server"></OBJECT>

<!--#include file="./library/utils.inc"-->
<!--#include file="./library/adojavas.inc"-->
<!--#include file="./library/db.inc"-->

<%
Response.Buffer = true;

CheckUser(Application("UserLevel"));

var sSQL = "";

var iNodeId = FormGetInteger("iNodeId", -1);
var iLanguageId = FormGetInteger("oComboLanguageId",
-1); var iListId = FormGetInteger("iListId", -1);
var strContentTitle =
Request.Form("oEditContentTitle").Count > 0 ?
Request.Form("oEditContentTitle").Item(1) : "";
var strContentSubTitle =
Request.Form("oEditContentSubTitle").Count
0 ? Request.Form("oEditContentSubTitle").Item(1) : "";

var strContentImage1 =
Request.Form("oEditContentImage1").Count > 0 ?
Request.Form("oEditContentImage1").Item(1) : "";
var strContentImage2 =
Request.Form("oEditContentImage2").Count > 0 ?
Request.Form("oEditContentImage2").Item(1) : "";
var strDocumentLink =
Request.Form("oEditDocumentLink").Count > 0 ?
Request.Form("oEditDocumentLink").Item(1) : "";
var strDocumentLinkDescription =
Request.Form("oEditDocumentLinkDescription").Count > 0 ?
Request.Form("oEditDocumentLinkDescription").Item( 1) : "";
var strContentBody =
Request.Form("oTextAreaContentBody").Count
0 ? Request.Form("oTextAreaContentBody").Item(1) : "";

var bMoreContents = FormGetInteger("iMoreContents", 0)
== 1 ? true : false;
var Fil1 = Request.Form("Fil1").Count > 0 ?
Request.Form("Fil1").Item(1) : "";
var Fil2 = Request.Form("Fil2").Count > 0 ?
Request.Form("Fil2").Item(1) : "";
var Fil3 = Request.Form("Fil3").Count > 0 ?
Request.Form("Fil3").Item(1) : "";
var Fil4 = Request.Form("Fil4").Count > 0 ?
Request.Form("Fil4").Item(1) : "";

if((iNodeId == -1) || (iLanguageId == -1) || (iListId == -1))
Response.Redirect("./tree_cms.asp");

cn.Open(Application("ADOConnectionString"));

cm.ActiveConnection = cn;

sSQL = "SELECT content_id FROM Content_Text WHERE topic_id=" +
iNodeId; sSQL += " AND language_id=" + iLanguageId + " AND list_id="
+ iListId + " AND preview=0";

rst.Open(sSQL, cn);

if(!rst.EOF)
{
// Update
cm.CommandText = "UPDATE Content_Text SET title = ?, sub_title = ?,
body = ?, picture_file_name_1 = ?, ";
cm.CommandText += "picture_file_name_2 = ?, Fil1 = ?, Fil2 = ?, Fil3
= ?, Fil4 = ?, document_link = ?, document_link_description = ?,";
cm.CommandText += "modification_date = " + GetActualDbDate() + ",
user_name = ? WHERE content_id=?";
cm.Parameters.Append(cm.CreateParameter("title", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("sub_title ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("body", adLongVarWChar,
adParamInput, 20480000));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_1",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_2",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil1", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil2", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil3", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil4", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link_description",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("user_name ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("content_i d", adInteger,
adParamInput));
cm("title") = CutString(strContentTitle, 255);
cm("sub_title") = CutString(strContentSubTitle, 255);
cm("body") = strContentBody;
cm("picture_file_name_1") = CutString(strContentImage1, 255);
cm("picture_file_name_2") = CutString(strContentImage2, 255);
cm("Fil1") = CutString(Fil1, 255);
cm("Fil2") = CutString(Fil2, 255);
cm("Fil3") = CutString(Fil3, 255);
cm("Fil4") = CutString(Fil4, 255);
cm("document_link") = CutString(strDocumentLink, 255);
cm("document_link_description") =
CutString(strDocumentLinkDescription, 255);
cm("user_name") = Session("UserName");
cm("content_id") = rst("content_id").value;
83 cm.Execute();
}
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''
line 83: cm.Execute();

Why does i work on my xp, but not on the 2000 server??????

I have also uploaded my code to another server, and it worked
perfectly there also..

Is there maby some options in iis that are set wrong???
Thanks!

Christopher Brandsdal


Jul 19 '05 #4
Check the permissions again!

If IUSR_<machinename> has Read/Write (RXW) then Creator/Owner needs Full
Control.
Otherwise, if you are have remove the special CreatorOwner user, then
IUSR_<machinename> needs Change (RWXD) permissions.

This is because Access needs to create the .ldb lockfile, which is created
in the same folder as the .mdb file. And it needs to delete it later on. So,
either IUSR_<machinename> needs Change (RWXD) or, since it is the Owner of
the .ldb lockfile, Creator/Owner needs Change (by default, I think C/O has
Full Control).

Cheers
Ken

"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:Oc**************@TK2MSFTNGP12.phx.gbl...
: hmm.. I have done this...
: But it still won't work!
: I think something else must be the problem..
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
: news:Op**************@TK2MSFTNGP09.phx.gbl...
: > This is an NTFS permissions problem. Give the IUSR_<machinename> account
: (or
: > whatever user context you are using) Read/Write permissions to the
folder
: > (and files) where the .mdb file is, and also to the Windows temp
: directory.
: >
: > Cheers
: > Ken
: >
: >
: > "Christopher Brandsdal" <ch***********@c2i.net> wrote in message
: > news:%2***************@TK2MSFTNGP10.phx.gbl...
: > : Hi!
: > :
: > : I have a problem running my code on 2000 server and iis5.0.
: > :
: > : The code runs perfectly on my localhost (xp iis5.1) but when i run it
on
: > : 2000 server iis5.0 I get this error:
: > :
: > : --------------------------------------
: > :
: > : operation must use an updateable query
: > :
: > : execute_insert_text_content.asp l 83
: > : --------------------------------------
: > :
: > : My code looks like this:
: > :
: > <snip>
: >
: >
:
:
Jul 19 '05 #5
also check microsoft.com website
there is a known issue with read-rights on a specific key in the registry
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:#e**************@TK2MSFTNGP10.phx.gbl...
Assuming this is an Access database (why wouldn't you think this information was relevant? Always tell us the type and version of database you are using when asking a database-related question - we are not looking over your
shoulder <grin>) I agree with Ken that this is a permissions issue. See
these articles:
http://www.aspfaq.com/show.asp?id=2062 - updatable cursor
http://www.aspfaq.com/show.asp?id=2009 - 80004005 errors

Depending on where this query is being run (in a regular page, or in the
session_onend event in global.asa), you need to give folder-level Change
permissions to both the IUSR and IWAM accounts for the folder containing the database. Do not assume these accounts are in the Everyone group (they're
not).

Also, if the database is on a remote machine, the account used to access
that database must be a domain-level account:
http://support.microsoft.com/default...b;EN-US;253580
Finally, there is a slight possibility that the query itself is at fault, so you should response.write the CommandText and see if it's a runnable query.
HTH,
Bob Barrows
Christopher Brandsdal wrote:
Hi!

I have a problem running my code on 2000 server and iis5.0.

The code runs perfectly on my localhost (xp iis5.1) but when i run it
on 2000 server iis5.0 I get this error:

--------------------------------------

operation must use an updateable query

execute_insert_text_content.asp l 83
--------------------------------------

My code looks like this:
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''

<%@ LANGUAGE=JScript %>
<% Session.LCID = 1044 %>
<OBJECT id=cn PROGID="ADODB.Connection" RUNAT="server"></OBJECT>
<OBJECT id=rst PROGID="ADODB.Recordset" RUNAT="server"></OBJECT>
<OBJECT id=cm PROGID="ADODB.Command" RUNAT="server"></OBJECT>

<!--#include file="./library/utils.inc"-->
<!--#include file="./library/adojavas.inc"-->
<!--#include file="./library/db.inc"-->

<%
Response.Buffer = true;

CheckUser(Application("UserLevel"));

var sSQL = "";

var iNodeId = FormGetInteger("iNodeId", -1);
var iLanguageId = FormGetInteger("oComboLanguageId",
-1); var iListId = FormGetInteger("iListId", -1);
var strContentTitle =
Request.Form("oEditContentTitle").Count > 0 ?
Request.Form("oEditContentTitle").Item(1) : "";
var strContentSubTitle =
Request.Form("oEditContentSubTitle").Count
0 ? Request.Form("oEditContentSubTitle").Item(1) : "";

var strContentImage1 =
Request.Form("oEditContentImage1").Count > 0 ?
Request.Form("oEditContentImage1").Item(1) : "";
var strContentImage2 =
Request.Form("oEditContentImage2").Count > 0 ?
Request.Form("oEditContentImage2").Item(1) : "";
var strDocumentLink =
Request.Form("oEditDocumentLink").Count > 0 ?
Request.Form("oEditDocumentLink").Item(1) : "";
var strDocumentLinkDescription =
Request.Form("oEditDocumentLinkDescription").Count > 0 ?
Request.Form("oEditDocumentLinkDescription").Item( 1) : "";
var strContentBody =
Request.Form("oTextAreaContentBody").Count
0 ? Request.Form("oTextAreaContentBody").Item(1) : "";

var bMoreContents = FormGetInteger("iMoreContents", 0)
== 1 ? true : false;
var Fil1 = Request.Form("Fil1").Count > 0 ?
Request.Form("Fil1").Item(1) : "";
var Fil2 = Request.Form("Fil2").Count > 0 ?
Request.Form("Fil2").Item(1) : "";
var Fil3 = Request.Form("Fil3").Count > 0 ?
Request.Form("Fil3").Item(1) : "";
var Fil4 = Request.Form("Fil4").Count > 0 ?
Request.Form("Fil4").Item(1) : "";

if((iNodeId == -1) || (iLanguageId == -1) || (iListId == -1))
Response.Redirect("./tree_cms.asp");

cn.Open(Application("ADOConnectionString"));

cm.ActiveConnection = cn;

sSQL = "SELECT content_id FROM Content_Text WHERE topic_id=" +
iNodeId; sSQL += " AND language_id=" + iLanguageId + " AND list_id="
+ iListId + " AND preview=0";

rst.Open(sSQL, cn);

if(!rst.EOF)
{
// Update
cm.CommandText = "UPDATE Content_Text SET title = ?, sub_title = ?,
body = ?, picture_file_name_1 = ?, ";
cm.CommandText += "picture_file_name_2 = ?, Fil1 = ?, Fil2 = ?, Fil3
= ?, Fil4 = ?, document_link = ?, document_link_description = ?,";
cm.CommandText += "modification_date = " + GetActualDbDate() + ",
user_name = ? WHERE content_id=?";
cm.Parameters.Append(cm.CreateParameter("title", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("sub_title ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("body", adLongVarWChar,
adParamInput, 20480000));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_1",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("picture_f ile_name_2",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil1", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil2", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil3", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("Fil4", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("document_ link_description",
adVarChar, adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("user_name ", adVarChar,
adParamInput, 255));
cm.Parameters.Append(cm.CreateParameter("content_i d", adInteger,
adParamInput));
cm("title") = CutString(strContentTitle, 255);
cm("sub_title") = CutString(strContentSubTitle, 255);
cm("body") = strContentBody;
cm("picture_file_name_1") = CutString(strContentImage1, 255);
cm("picture_file_name_2") = CutString(strContentImage2, 255);
cm("Fil1") = CutString(Fil1, 255);
cm("Fil2") = CutString(Fil2, 255);
cm("Fil3") = CutString(Fil3, 255);
cm("Fil4") = CutString(Fil4, 255);
cm("document_link") = CutString(strDocumentLink, 255);
cm("document_link_description") =
CutString(strDocumentLinkDescription, 255);
cm("user_name") = Session("UserName");
cm("content_id") = rst("content_id").value;
83 cm.Execute();
}
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''
line 83: cm.Execute();

Why does i work on my xp, but not on the 2000 server??????

I have also uploaded my code to another server, and it worked
perfectly there also..

Is there maby some options in iis that are set wrong???
Thanks!

Christopher Brandsdal


Jul 19 '05 #6
Thanks!
oops..
I forgot that when I burn the files to a cd it autmaticly makes them "read
only" when I copy them back to disc....

I AM SO SORRY :)

Thanks ALOT for helping me realize that there's nothing wrong with the
system, it's just me ;)
"Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
news:O0*************@TK2MSFTNGP10.phx.gbl...
Check the permissions again!

If IUSR_<machinename> has Read/Write (RXW) then Creator/Owner needs Full
Control.
Otherwise, if you are have remove the special CreatorOwner user, then
IUSR_<machinename> needs Change (RWXD) permissions.

This is because Access needs to create the .ldb lockfile, which is created
in the same folder as the .mdb file. And it needs to delete it later on. So, either IUSR_<machinename> needs Change (RWXD) or, since it is the Owner of
the .ldb lockfile, Creator/Owner needs Change (by default, I think C/O has
Full Control).

Cheers
Ken

"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:Oc**************@TK2MSFTNGP12.phx.gbl...
: hmm.. I have done this...
: But it still won't work!
: I think something else must be the problem..
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
: news:Op**************@TK2MSFTNGP09.phx.gbl...
: > This is an NTFS permissions problem. Give the IUSR_<machinename> account : (or
: > whatever user context you are using) Read/Write permissions to the
folder
: > (and files) where the .mdb file is, and also to the Windows temp
: directory.
: >
: > Cheers
: > Ken
: >
: >
: > "Christopher Brandsdal" <ch***********@c2i.net> wrote in message
: > news:%2***************@TK2MSFTNGP10.phx.gbl...
: > : Hi!
: > :
: > : I have a problem running my code on 2000 server and iis5.0.
: > :
: > : The code runs perfectly on my localhost (xp iis5.1) but when i run it on
: > : 2000 server iis5.0 I get this error:
: > :
: > : --------------------------------------
: > :
: > : operation must use an updateable query
: > :
: > : execute_insert_text_content.asp l 83
: > : --------------------------------------
: > :
: > : My code looks like this:
: > :
: > <snip>
: >
: >
:
:

Jul 19 '05 #7
Oh yeah - that's another issue I didn't even think of!

You run into this as well if you put your .mdb file inside your webroot, and
you run the FPSE "tighten security" wizard, and your .mdb file isn't inside
the "special" /fpdb folder.

Glad you got it sorted out.

Cheers
Ken

"Christopher Brandsdal" <ch***********@c2i.net> wrote in message
news:O1**************@TK2MSFTNGP11.phx.gbl...
: Thanks!
: oops..
: I forgot that when I burn the files to a cd it autmaticly makes them "read
: only" when I copy them back to disc....
:
: I AM SO SORRY :)
:
: Thanks ALOT for helping me realize that there's nothing wrong with the
: system, it's just me ;)
:
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
: news:O0*************@TK2MSFTNGP10.phx.gbl...
: > Check the permissions again!
: >
: > If IUSR_<machinename> has Read/Write (RXW) then Creator/Owner needs Full
: > Control.
: > Otherwise, if you are have remove the special CreatorOwner user, then
: > IUSR_<machinename> needs Change (RWXD) permissions.
: >
: > This is because Access needs to create the .ldb lockfile, which is
created
: > in the same folder as the .mdb file. And it needs to delete it later on.
: So,
: > either IUSR_<machinename> needs Change (RWXD) or, since it is the Owner
of
: > the .ldb lockfile, Creator/Owner needs Change (by default, I think C/O
has
: > Full Control).
: >
: > Cheers
: > Ken
: >
: > "Christopher Brandsdal" <ch***********@c2i.net> wrote in message
: > news:Oc**************@TK2MSFTNGP12.phx.gbl...
: > : hmm.. I have done this...
: > : But it still won't work!
: > : I think something else must be the problem..
: > :
: > : "Ken Schaefer" <ke*******@THISadOpenStatic.com> skrev i melding
: > : news:Op**************@TK2MSFTNGP09.phx.gbl...
: > : > This is an NTFS permissions problem. Give the IUSR_<machinename>
: account
: > : (or
: > : > whatever user context you are using) Read/Write permissions to the
: > folder
: > : > (and files) where the .mdb file is, and also to the Windows temp
: > : directory.
: > : >
: > : > Cheers
: > : > Ken
: > : >
: > : >
: > : > "Christopher Brandsdal" <ch***********@c2i.net> wrote in message
: > : > news:%2***************@TK2MSFTNGP10.phx.gbl...
: > : > : Hi!
: > : > :
: > : > : I have a problem running my code on 2000 server and iis5.0.
: > : > :
: > : > : The code runs perfectly on my localhost (xp iis5.1) but when i run
: it
: > on
: > : > : 2000 server iis5.0 I get this error:
: > : > :
: > : > : --------------------------------------
: > : > :
: > : > : operation must use an updateable query
: > : > :
: > : > : execute_insert_text_content.asp l 83
: > : > : --------------------------------------
: > : > :
: > : > : My code looks like this:
: > : > :
: > : > <snip>
: > : >
: > : >
: > :
: > :
: >
: >
:
:
Jul 19 '05 #8
Create Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics
12
8447
XmlSerializer & FileNotFound (NOT the usual problem!)
by: SJD | last post by:
I've just read Christoph Schittko's article on XmlSerializer: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxmlnet/html/trblshtxsd.asp . . . and very informative it is too....
.NET Framework
4
10326
Report: Running Total Problem
by: Bill Dika | last post by:
Hi I am trying to calculate a running total of a calculated textbox (tbAtStandard) in GroupFooter1 for placement in a textbox (tbTotalAtStandard) on my report in Groupfooter0. The problem...
Microsoft Access / VBA
3
1950
Problem with the ListBox
by: jayderk | last post by:
Hello All, I am running in to a situation where the listbox is not refreshing for me. I am using a timer to cycle every second and call the timer_elapsed() event. in the time_elapsed event...
C# / C Sharp
4
11141
Application.Exit problem
by: Chuck | last post by:
Hello everybody, I need to abort execution during start up, while the constructor called by Application.Run is executing. If the database fails to connect during my application's startup I...
C# / C Sharp
5
6269
.Net Remoting problem: No connection could be made because the target machine
by: Data | last post by:
In my project I want to execute some commands on the remote machine. I am using .Net Remoting to achieve this. My server which is an exe is copied on the remote machine and it receives command from...
C# / C Sharp
1
1693
Postback problem - different .net-versions?
by: Frankieboy | last post by:
I believe I've got a postback problem on our site. The strange thing is that everything works fine on my developing version, but not on the production site. I'm wondering if there may be different...
C# / C Sharp
6
3784
Problem: Request time out
by: Ammar | last post by:
Dear All, I'm facing a small problem. I have a portal web site, that contains articles, for each article, the end user can send a comment about the article. The problem is: I the comment length...
ASP.NET
8
9693
VB.Net file access problem with UNC
by: Sarah | last post by:
I need to access some data on a server. I can access it directly using UNC (i.e. \\ComputerName\ShareName\Path\FileName) or using a mapped network drive resource (S:\Path\FileName). Here is my...
Visual Basic .NET
4
1562
escape problem
by: Dan | last post by:
I'm using asp.net c# in my code behind I coded the following: ButtonAsynchronous.Attributes.Add("onclick", @" setTimeout( ""UpdateImg('AnimatedProgress','images/running.gif');"" , 50); "); ...
ASP.NET
4
3961
Problem relating to running Stored Procedures
by: nishi57 | last post by:
I hope I can get some help regarding this issue, which has been going on for a while. I have a desktop user who is having problem running "Stored Procedures". The DB2 Connect application works fine...
DB2 Database
0
7112
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
6974
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
7146
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
7356
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
General
0
3084
Trying to create a lan-to-lan vpn between two differents networks
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
Networking - Hardware / Configuration
0
3074
Windows Forms - .Net 8.0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
Visual Basic .NET
0
1389
transfer the data from one system to another through ip address
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
C# / C Sharp
1
628
muto222
How to add payments to a PHP MySQL app.
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
PHP
0
277
bsmnconsultancy
Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
General

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us