2. ASPRunnerPro General questions
  3. Erorr in updating data
This topic is locked

Erorr in updating data

 		1/10/2005 12:53:20 PM
ASPRunnerPro General questions
A
 agung author

Dear Admin
At first time I use ASPRunner, I was suprised b coz its really easy to use and user friendly. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1011&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Would you help me please. I'm encountering a problem when updating data into the databases. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1011&image=2&table=forumtopics' class='bbc_emoticon' alt=':(' />

Here are the erorr displayed.
Error number : -2147467259
Error description : [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
URL : /ASPRunner/Installation_BNI_edit.asp
SQL query : update [Installation_BNI] set [Remote Name]='BNI_Yogyakarta', [S/N]=397117, [IP SNMP]='10.1.5.4', [IP Eth Modem]='10.77.5.254', [SQF]=9.6, [ACQ]=160, [Timing Offset]=38866, [Installer]='Poerwahono [TM]', [Date Install]=NULL, [Integrasi]=NULL, [Online]=NULL, [Aplikasi]=' SKK dong', [Remarks]='' where [Remote Name]='BNI_Yogyakarta'
Thanks 4 u r help
Agung Nugroho
B
 		baltrusj 1/10/2005

Good luck. Nobody seems to want to help with this issue. I have it too. You can try emailing Sergey the developer and see what you get. Also, try the FAQ on the ASPrunner site. You have to put your database in the correct directory on your server, not the default "db" folder the software creates. But the tricky part is that you have to update the connection strings, or the code the tells the server where that database now resides. Now, the closest code I have founds is in the file: getfile.asp, I have changed it but I still get that error. I have still have no clue.
Joe

email me if you find anything out

joe@edpsyched.com
Sergey Kornilov admin 1/11/2005

Joe,
I have sent a reply to your personal email.
Agung,

your question is answered in great details in ASPRunner FAQ. This is a very first question there: http://www.xlinesoft.com/asprunnerpro/faq.htm
501133 1/15/2005

Hi Admin,
Thanks for u r advice but unfortunately it can't work.

  • Add an Everyone user with Full Access
  • My computer was using Win XP so i check to not using simple file sharing
    What else should i try so i can updates my database.

    Please help.
    thanks
Sergey Kornilov admin 1/16/2005

Agung,
make sure you assign permissions on correct DB folder which resides in ASPRunner's output folder.
501134 1/19/2005

Yes I have set my "working" folder permision with full access on everyone user.
I just want to know what type of connection that you provide for connecting to the databases. Yesterday, i try the connection with DSN-Less connection to the Access Databases from asp example that i found on the internet.

And it's Beautifully works.
And now how about the ASPRunner why it can't works?
A
 		aspbeginner 1/19/2005

Make sure the IUSR account has the proper permissions for the folder.