2. ASPRunnerPro General questions
  3. Can't add, and save
This topic is locked

Can't add, and save

 		3/2/2004 11:25:50 PM
ASPRunnerPro General questions
author

Hi,
I am new to this and I am having problem with the following:
I can view the database fine, but when I edit the information, it does not allow me to save it. Also, It wont allow me to add information into the databse. My Database is located outside the inetpub directory. Is this causing the problem? If so, should I move my database to that directory?
Second question:

  1. My table contains of
    No Name Quote Quote File

    1 A Q153 Q153.pdf - Clicking Q153.pdf will open the pdf file

    2 B Q154 Q154.pdf
    I want to create a link to the pdf file for my Q153. The pdf file is located in the output subsirectoty. What's the best way to do this? Can we eliminate the Q153.pdf from the table and still allow me to search based on Quote.
    No Name Quote

    1 A Q153 - Clicking Q153 will open the Q153.pdf file and I can do search based on Quote
    Question 3

    Is there an easy way to add the new information and upload the pdf file to specific directory created for pdf file only? What asp code do I need to edit and how to specify to retrieve the pdf file from that image directory.
    Thanks
    Adam
501024 3/3/2004

By the way, the error msg I got when I try to edit or save is
Error Number: -2147467259
Error Desc: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query]
URL: /ASPRunner/RFQ_edit.asp
I really need help and step by step process to do this.
Thank you
Sergey Kornilov admin 3/3/2004

First off all I would recommend to check this artcile:

http://www.xlinesoft.com/asprunner/faq.htm#updatable
Let me know if you still have edit/add problems after reading this.
501025 3/3/2004

From the start of the project.
Database located in C:inetpub\wwwroot\TEST.mdb
I selected Database spreadsheet file
Database file:

C:\Inetpub\wwwroot\TEST.mdb

No log in and password
Use Server.Map Path:

mdb
Created log in page with Hardcoded username and password:

Username: ABC

Password: TEST
Select a Website/Virtual Directory or Browse for Output directory:

ASPRunner(C:\Program files\ASPRunner\Output)

C:\Program files\ASPRunner\Output

Website Url:

http://localhost:80/ASPRunner
Click Build now and view it in browser. Everything is good and working fine except when I try to add or edit data. The following is the error msg I got. I do have full permission.
Error number -2147467259

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

URL /ASPRunner/RFQ_edit.asp

SQL query update [RFQ] set [ACCT]='GAIA', [RFQ]='MLD1RFQ008NH04', [RFQ DATE]='2/18/2004', [DUE DATE]='2/25/2004', [QUOTE]='Q155311', [RECEIVED]='2/26/2004', [SUBMITTED]='2/26/2004' where [ID]=1
Thank you,
Sergey Kornilov admin 3/3/2004

you doing everything correct however there is one more thing you need to do.
While you have full permissions Internet Information Server uses IUSR_... user that has limited permissions on your box. You need to give this user full permissions on directory where database file is located

(C:\Program files\ASPRunner\Output\mdb). Also you can give full permissions to Everyone on this directory.
Does it make some sense?
M
 		mashacpa 3/3/2004

For dummies, please explain step-by-step how to set up permissions for IUSR user.
Thanks!
Masha
501026 3/3/2004

It makes sense, but please tell me how to do that step by step since I am a free newbie.
Thank you,
501027 3/3/2004

Thanks for the help. It is working beatifully now.
I did give permission.

I went to the C:ASPRunner\Output\bd
Right click on the db directory and choose properties.

Then click on the security property tab and check allow boxes.

Click Apply and it works.
Thanks