Solved

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

Posted on 2003-12-01
12
90,396 Views
Last Modified: 2012-08-13
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\DIAGNOSTICS\../includes/databaseFunctions.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(mySQL)
 
 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="&Server.Urlencode("Error 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.
0
Comment
Question by:camdonsquire
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
12 Comments
 
LVL 10

Expert Comment

by:jobrienct
ID: 9853107
it sounds like you are trying to .execute a select query when .exevute is reserved for update append and delete. what is your Sql statement?

John
0
 
LVL 32

Expert Comment

by:jadedata
ID: 9853166
Hey camdonsquire!

 show the sql here.  this seems to be where the issue is...

regards
Jack
0
 
LVL 7

Expert Comment

by:wsteegmans
ID: 9853810
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!
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 10

Expert Comment

by:jobrienct
ID: 9853954

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
0
 
LVL 7

Expert Comment

by:wsteegmans
ID: 9853976
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,
0
 
LVL 10

Expert Comment

by:jobrienct
ID: 9853984
glad to know it, thanks, I'll keep an eye out next time.

John
0
 

Author Comment

by:camdonsquire
ID: 9857325
How do i change the Internet Guest Account permissions?
0
 
LVL 7

Accepted Solution

by:
wsteegmans earned 500 total points
ID: 9857386
Hi camdonsquire,

Open Windows Explorer and find your Access-DB. I prefer you copy this DB in a seperate folder, let's say _database.
Next, right click with your mouse on this folder and choose properties. Choose the tab 'Security'.

No, we will add this Internet Guest Account, so click the button Add and look for a user called IUSR_MACHINENAME where MACHINENAME is the name of your server/computer.

Once you added this new user, give it full permission. Last check, the option 'Allow inheritable permissions from parent to propagate to this object' must be activated.

So, press Apply or OK and try again ...

Succes!

Regards!
0
 
LVL 9

Expert Comment

by:ornicar
ID: 10075551
----------------------------------------------------------------------------------------
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

---------------------------------------------------------------------------------------------
0
 
LVL 39

Expert Comment

by:stevbe
ID: 10210341
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
0
 
LVL 2

Expert Comment

by:fadixp
ID: 12451078
it seems he is fired !
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question