Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Jul 2007
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trouble in web Database

    I have a website written in ASP.
    I am facing a problem, that i am unable to write anything to the database (I am using MS Access database). I can easily read from the the db without any problems.

    When i submit a form, which needs to be stored in the db, i get an error stating that database or object is write protected.
    It works perfectly fine on localhost...

    i am using this particular code to connect to the db in global.asa file:


    Application("connStr") = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("cart.mdb") & ";User ID=admin;password=;"
    I have also tried this method :

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("\somepath\dbname.mdb") & ";User Id=admin;Password=pass;"
    Can anyone plz help me...

    PS : another thing i wanted to inform is, that the submit form button does not work in firefox... nothing happens when it is clicked...


    the problem occurs after trying to buy any item from the shopping cart, when the user fills in an order-form...

    it is at that particular page, when i click on submit, that i get this error message.
    also, the submit button doesn't work in firefox

  • #2
    Regular Coder
    Join Date
    Mar 2006
    Posts
    187
    Thanks
    5
    Thanked 0 Times in 0 Posts
    have you got a link to your website? i'm no expert, but writing to the database sounds like a permission problem on your host. if they provide a folder called db use it, this is set up especially for databases!

  • #3
    Regular Coder
    Join Date
    Jan 2005
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts
    you need to set permissions on the access database and the directory that contains the db to read/write. most hosts will tell you where you need to place the access database or at least how to set the permissions correctly.


  •  

    Posting Permissions

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