|
| |
|
|
yorkshireman
Posts: 2
Joined: 3/14/2004
Status: offline
 |
ASP Access Update Problems after installing Office SP3 - 3/14/2004 10:10:30
Hi There,
As can be seen form the subject line I am having problems with updating rows in an access 2000 database using ASP's which are created using Frontpage 2002. The updates worked fine until I installed SP3 3 days ago and since then it has been to say the least frustrating. At first even the retrievals wouldn't work until I discovered that Microsft had posted a KB article about it this can be seen at http://support.microsoft.com/default.aspx?kbid=299911 which refers to a data mismatch occuring when you use numeric fields in the query (ie ID). I applied this fix and at least my retrievals are working fine that use the numeric id value. The problem is my UPDATE query which throws the error.
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers
Background
The access2000 databse has been imported into the FP2002 web and resides in the /fpdb directory so the global.asa has been created by FP and connection strings etc work fine.
So far I have tried the following to resolve the issue.
SQL Query (As used in the DBW)
UPDATE DISTINCTROW hints
SET hint_title = '::title::',
description = '::desc::'
WHERE id = ::id::;
The Resultant Webot Code
<%
fp_sQry="UPDATE DISTINCTROW hints SET hint_title = '::title::', description = '::desc::' WHERE id = ::id::"
fp_sDefault="title=&desc=&id=0"
fp_sNoRecords="No records returned."
fp_sDataConn="forkeepsakes"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="18104" --><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --><p align="center">
The hint, desc and id values are all passed through to the UPDATE ASP from a form which in itself uses an ASP to populate it using the id value to retrieve the data from the database.
The passed paramters have been tested in a SELECT query and pull the data back fine, it is just the UPDATE where the problem lies, saying that I have been so engrossed in this I haven't tested the DELETE query.
- reinstalled FP2002
- removed and reinstalled the server extensions.
- set the fpdb directory and mdb file to read write.
- made sure the PC_USR has anonymous access.
at this point I am running out of ideas, so anyone out there got any ideas I will be only too pleased to listen.
Kindest Regards
George
|
|
|
|
yorkshireman
Posts: 2
Joined: 3/14/2004
Status: offline
|
RE: ASP Access Update Problems after installing Office SP3 - 3/16/2004 4:52:45
Hi There,
Thanks for that but already tried that and no luck. Tried many other things too like removing office and FP, clearing the crap out of the registery and reinstalling the software but no luck.
Eventually I have since uninstalled the following Service Packs
SP2 Q329115
SP2 Q811114
Initially no difference then I uninstalled the FP server extensions (IIS5.1) and reinstalled then stopped and restarted the web server ......... KARAMBA IT WORKS!!!!!.
Just one point to note and I have no reason to think there's anything in it but it took 2 remove and installs to get the server extensions back on (ie removed first time and reinstalled no errors but FP wouldn't fire up and complained about the extensions not being installed) Did a second remove and install and this time it worked.
Its been a frustrating few days but hopefully some good will come out of this and it will help someone else, however there is still and issue with SP3 I reckon.
Best Wishes
George
| |
|
 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 
k¥ 
