|
| |
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
 |
" Operation must use an updateable query" - 10/23/2002 14:30:25
This query use to work on our old server. Now that we moved it to a new server and reestablished the database connections i get this error when i click update on my update pages. Any Ideas?
Database Results Error
Description: [Microsoft][ODBC dBase Driver] Operation must use an updateable query.
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers
< Message edited by Spooky -- 1/11/2003 7:56:31 PM >
|
|
|
|
Spooky
Posts: 26657
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: updateable query - 10/23/2002 15:12:25
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=107
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þ k¥
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: updateable query - 10/24/2002 6:03:57
Hi,
Doug G,
Congratulations for the new forum. I have just registered.
Hisham
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: updateable query - 10/24/2002 6:06:21
Hi,
Just a thought.
When you create a query in Access and that query depends on more than one table, or it returns group values like Distinct, sum ..etc it will not be an updateable query. You can' t even use it to add records in Access itself.
Best regards
Hisham
| |
|
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
|
RE: updateable query - 11/6/2002 11:03:59
I contacted my provider and they tell me to use this:
SQL = " UPDATE Products Set UnitPrice = 2;"
Set Conn = Server.CreateObject(" ADODB.Connection" )
Conn.Mode = 3 ' 3 = adModeReadWrite
Conn.Open " myDSN"
Conn.Execute(SQL)
Conn.Close
Where is this code suppose to go? On the page or in the global.asa file. I haven' t been able to find any place where it fits in.
| |
|
|
|
Spooky
Posts: 26657
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: updateable query - 11/6/2002 14:13:00
what does your existing code look like?
I assume you are writing a record to the database?
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þk¥
| |
|
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
|
RE: updateable query - 11/6/2002 14:23:13
Yes that is correct. I' m trying to add/update/delete records from the database. It worked on old server without a problem, now that we moved the site it refuses to do so.
Here is the code
<%
fp_sQry=" SELECT * FROM CALENDAR ORDER BY EVENT_DATE ASC"
fp_sDefault=" "
fp_sNoRecords=" No records returned."
fp_sDataConn=" mainpagequery"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=" EVENT_NAME"
fp_sMenuValue=" EVENT_NAME"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file=" _fpclass/fpdbrgn1.inc" -->
<!--webbot bot=" DatabaseRegionStart" endspan i-CheckSum=" 25530" -->
<form METHOD=" POST" action=" edit_cal2.asp" >
<!--webbot bot=" PurpleText"
PREVIEW=" Set this form' s properties so it submits user input to the appropriate page."
-->
<table BORDER=" 0" width=" 100%" >
<tr>
<td width=" 148" ><b>Event Name</b></td>
<td width=" 284" ><input TYPE=" TEXT" NAME=" EVENT_NAME" SIZE=" 40" VALUE=" <%=FP_FieldHTML(fp_rs," EVENT_NAME" )%>" ></td>
<td></td>
</tr>
<tr>
<td><b>Event Date</b></td>
<td><input TYPE=" TEXT" NAME=" EVENT_DATE" SIZE=" 40" VALUE=" <%=FP_FieldHTML(fp_rs," EVENT_DATE" )%>" ></td>
<td width=" 145" ></td>...........................................
| |
|
|
|
Spooky
Posts: 26657
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: updateable query - 11/6/2002 15:26:56
It tends to suggest that the permissions are incorrect.
I would direct your host to :
http://www.dougscode.com/faq/faq_doug1/dbp/dbp.asp?pkey=q1020
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þk¥
| |
|
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
|
RE: updateable query - 11/6/2002 16:45:21
I' m not sure I fully understand. I opened the site live with FrontPage and right clicked on the fpdb folder and looked and the check box is checked for running scripts. I went into the server via ftp and right clicked on the database file to see if everyone had permission to write to it, but the server does not allow that type of action.
| |
|
|
|
Spooky
Posts: 26657
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: updateable query - 11/6/2002 18:47:20
You cant do it via Frontpage, youll need to go through your host.
It seems they are saying its a coding problem.
As you are using the DRW, Id suggest this wasnt the case and the permissions are incorrect at the hosts end.
As a second to last resort, try re-importing the database into the default folder in your live web to see if it kick starts the correct permissions.
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þk¥
| |
|
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
|
RE: updateable query - 11/13/2002 11:34:45
Alright. I contacted my the provider of the website and they say that I have to switch everything over to a *.mdb file. I made a database results page and now I get this error.
Database Results Error
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key ' Temporary (volatile) Jet DSN for process 0x864 Thread 0x81c DBC 0xa62d4ac Jet' .
What can I do. This is geting me mad 
| |
|
|
|
nmathews
Posts: 50
Joined: 2/10/2002
From:
Status: offline
|
RE: updateable query - 11/13/2002 11:43:51
I figured it out. I had the *.mdb database so it would upload to the server. It uploaded all my old dbf files but just not the *.mdb file.
Thanks for all your support!
| |
|
|
|
LynxEye
Posts: 1
Joined: 11/6/2004
Status: offline
|
RE: " Operation must use an updateable query" - 11/6/2004 9:48:48
I think i have the solution, at least it worked for me. I'm an XP Pro user having NTFS file system. Running ASP scripts that does insert/update query's on an Access DB.
- Go to your Control Panel
- Administrative Tools > IIS
- Expand the folder of your site/application
- Right-click the DB folder (just the folder where your .mdb is in)
- Go to "All-tasks" and click "Permissions Wizard"
- Click "Next" for 4 times, without changing anything and finish
You can probably do the same on a folder lower in the tree, but what the hell.. this worked..
< Message edited by LynxEye -- 11/6/2004 9:57:20 >
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 