I am running Win XP Pro with IIS5.
I have a ASP shopping cart setup (or not) and when i try to write information to the access database i get the following error.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
C:\INETPUB\WWWROOT\DIAGNOS
TICS\../in
cludes/dat
abaseFunct
ions.asp, line 92
When i went to that line of code i got the following sub routine:-
sub updateDatabase(mySQL, rsTemp, scriptName)
call openDb()
(92)set rsTemp=connTemp.execute(my
SQL)
if err.number <> 0 then
if pTrapDbErrors=0 or (err.number<>9 and err.number<>5 and err.number<>6 and err.number<>13 and err.number<>94 and err.number<>424 and err.number<>3265 and err.number>-2000000000) then
response.redirect "comersus_supportError.asp
?error="&S
erver.Urle
ncode("Err
or in " &scriptName& ", error: "&Err.Description& " - Err.Number:"&Err.number&" - SQL:"&mySQL)
end if
end if
end sub
The company site is down because of this error and my employer is getting very cheesed with me so some
one please save my job.
Start Free Trial