camdonsquire
asked on
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
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.
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
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
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
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.
Hey camdonsquire!
show the sql here. this seems to be where the issue is...
regards
Jack
show the sql here. this seems to be where the issue is...
regards
Jack
Check the permissions in Win2K of WinXP of your AccessDB. Because, you're using ASP, your database is opened by the Internet Guest Account of the PC (IUSR_NameOfPC).
By default, this useraccount has just read-permissions ... So, updating is not possible, and that's why the OLE DB Provider raises this error ...
So, give the Internet Guest Account IUSR_PCName full access to your DB.
Regards!
By default, this useraccount has just read-permissions ... So, updating is not possible, and that's why the OLE DB Provider raises this error ...
So, give the Internet Guest Account IUSR_PCName full access to your DB.
Regards!
Would it throw THAT error? it seems to be complaining of attempt to execute a non-updating query, not complaining about permission to do so... hrm. Would be an odd choice of errors to use for a permissions error.
John
Hi John,
It indeed throws that error ... when executing update queries (insert/update/delete) with insufficient permissions on the DB (for the Internet Guest Account), it returns this error ...
Indeed a little bit strange ...
Regards,
It indeed throws that error ... when executing update queries (insert/update/delete) with insufficient permissions on the DB (for the Internet Guest Account), it returns this error ...
Indeed a little bit strange ...
Regards,
glad to know it, thanks, I'll keep an eye out next time.
John
John
ASKER
How do i change the Internet Guest Account permissions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- --
This question has been abandoned and needs to be finalized.
You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
ornicar
Cleanup Volunteer
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- -------
This question has been abandoned and needs to be finalized.
You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
ornicar
Cleanup Volunteer
--------------------------
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:
Accept: wsteegmans {http:#9857386}
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
stevbe
EE Cleanup Volunteer
I will leave the following recommendation for this question in the Cleanup topic area:
Accept: wsteegmans {http:#9857386}
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
stevbe
EE Cleanup Volunteer
it seems he is fired !
John