...

View Full Version : cant work in another pc



andceh
02-26-2006, 09:32 AM
Hi,
I'm currently develop an inventory system.After i had tested the system in my own pc with no error but I had received 2 error message when i moved to another pc. I"m using ASP language as my system with the Macromedia Dreamweaver. Two types of the error is :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/andrew/reservation/reserveform.asp, line 109


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.

What does is means by "Operation must use an updateable query"??I"m looking for someone to help me to solve this problem.
Thanks.

Brandoe85
02-26-2006, 09:43 AM
Usually has to do with permissions, take a look at the following article:
http://support.microsoft.com/kb/q175168/

Good luck;

andceh
02-26-2006, 10:14 AM
Thanks for your reply. I had visited to "http://support.microsoft.com/kb/q175168/" but my coding seems like nothing wrong with it.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/chew/login/changecontent.asp, line 69

<%
Dim rstSearch
Dim strSQL
Dim strAction
Dim strMemberid
Dim strOldpassword
Dim strNewpassword1
Dim strNewpassword2
Dim strPassword
%>

<!--#include file="../lib/dbconnection.asp"-->

<%
strMemberid = Session("memberid")
strOldpassword = Request.form("oldpassword")
strNewpassword1 = Request.form("newpassword1")
strNewpassword2 = Request.form("newpassword2")
strAction = Request.Form("action")

If Session("memberid") = "" Then
Response.redirect "../login/default.asp"
End If
%>

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Change Password Page</title>
</head>
<%
If strAction = "Home" Then
If session("membertype") <> "" Then
If Session("membertype") = "admin" Or Session("membertype") = "manager" Then
Response.redirect"../menu/adminmanright.asp"
Else
If Session("membertype") = "supervisor" Then
Response.redirect"../menu/supervisorright.asp"
Else
If Session("membertype") = "sales supervisor" Then
Response.redirect"../menu/salesright.asp"
End If
End If
End If
End If
End If

%>

<body>
<%
strSQL = "SELECT * FROM login WHERE memberid = '" & strMemberid & "'"
Set rstSearch = cnnSearch.Execute(strSQL)

strPassword = rstSearch.Fields("password").Value

If strAction = "Submit" Then
If strOldpassword <> "" And strNewpassword1 <> "" And strNewpassword2 <> "" Then
If strOldpassword <> strPassword Then
Response.redirect "invalidcontent.asp"
Else
If strNewpassword1 <> strNewpassword2 Then
Response.redirect "invalidcontent.asp"
Else
strSQL="UPDATE login SET password = '" & strNewpassword1 & "' WHERE memberid = '" & strMemberid & "'"
cnnSearch.Execute(strSQL) 69
Response.redirect "successchange.asp"
End If
End If
Else
Response.Write("<center><font face='Arial' color=#ff0000><b>Please Fill In The Blank...</b></font></center>")
End If
End If

%>

<form name='changepassword' method='post' target='_self'>
<br><br>
<center><h1><font face='Arial' size='5'>Please change your password</font></h1></center>
<br><br>

<center> <table border=0>
<tr>
<td align='right'><font face='Arial' size='4'>Member ID : </font></td>
<td><input type='text' value= <%=strMemberid%> size='20' name='memberid'></input></td>
</tr>
<tr>
<td align='right'><font face='Arial' size='4'>Old Password : </font></td>
<td><input type=password size='20' name='oldpassword'></input></td>
</tr>
<tr>
<td align='right'><font face='Arial' size='4'>New Password : </font></td>
<td><input type='password' size='20' name='newpassword1'></input></td>
</tr>
<tr>
<td align='right'><font face='Arial' size='4'>Confirm New Password : </font></td>
<td><input type='password' size='20' name='newpassword2'></input></td>
</tr>
<tr>
<td align='right'></td>
<td><input type='submit' value='Submit' name='action'></input>
<input type='reset' value='Reset'></input></td>
</tr>
</table></center>

<br><br><br>

<center>
<p><input type='submit' name='action' value='Home'></input></p>
</center>
</form>
<!--#include file="../lib/footer.asp"-->
</body>

</html>

GoComplain
02-27-2006, 04:56 AM
That is correct, usually the coding is not the problem with that it is in your IIS settings.

Your database file is in a certain directory. Usually called /db/ or something like that. If you have the ability to chage the "RIGHTS MANAGEMENT" it can be in any directory you would like.

Usually your Hosting provider can assist you with that. You database must have READ/WRITE permissions on it

By default when you upload a file to the server all files have READ ONLY attributes you must specify which files you would like to have READ & WRITE attributes.

Hope that helps



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum