SitePoint Sponsor

User Tag List

Results 1 to 9 of 9

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2008
    Location
    Malta
    Posts
    68
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    error '80004005'

    Dear all,

    I am new to ASP and I hope I am in the right forum
    I have a mailing list and everything is ok because I used it on another website but on the current it is giving me the below error
    Kindly let me know how I can solve the problem please

    Regards,
    Ziffa27

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

    /pgs/processMultimedia.asp, line 65
    Code on line 65: conn.execute(strSQL)

  2. #2
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,631
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    If the code worked fine on another host, then "updateable query" usually means the folder location where the DB file is stored does not have WRITE permission for the user account that runs the ASP code. You'll need to raise this with your web host admin.
    Ian Anderson
    www.siteguru.co.uk

  3. #3
    SitePoint Zealot
    Join Date
    Jan 2007
    Location
    Almere, The Netherlands
    Posts
    160
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by siteguru View Post
    If the code worked fine on another host, then "updateable query" usually means the folder location where the DB file is stored does not have WRITE permission for the user account that runs the ASP code. You'll need to raise this with your web host admin.
    You need MODIFY permissions!

  4. #4
    SitePoint Enthusiast
    Join Date
    Sep 2008
    Location
    Malta
    Posts
    68
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks I will send them an email with your comment
    Thanks a lot

  5. #5
    SitePoint Enthusiast
    Join Date
    Sep 2008
    Location
    Malta
    Posts
    68
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Okay, but i don't know how to do it

  6. #6
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,631
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Trust me - the IUSR_ComputerName account needs to be able to WRITE to the folder in which the database file resides. I've been there and done it and bought the T-shirt.
    Ian Anderson
    www.siteguru.co.uk

  7. #7
    SitePoint Enthusiast
    Join Date
    Sep 2008
    Location
    Malta
    Posts
    68
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Okay but i need to know how to do the thing
    Thanks to all

  8. #8
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,631
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    How to do what thing?

    If the server is hosted by someone else, then THEY should already know how to apply WRITE permission to the folder (and the folder contents).
    Ian Anderson
    www.siteguru.co.uk

  9. #9
    SitePoint Enthusiast
    Join Date
    Sep 2008
    Location
    Malta
    Posts
    68
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Okay thanks


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •