problems connecting to database

benbacardi · April 12th, 2005, 01:03 PM

im using windows XP Pro with IIS to run some ASP scripts on my local machine

however

if i use the following code:

Code:

SQL = "UPDATE competitors SET wins=" & (wins1 + 1) & " WHERE competitor='" & competitor1 & "'"

all of which is valid and produces the right string when i write it to the screen etc, it says:

Code:

Technical Information (for support personnel)

    * Error Type:
      Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
      [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
      /chess/addgame4.asp, line 66

    * Browser Type:
      Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.7.6) Gecko/20050321 Firefox/1.0.2

anyone know why? previously i had to set read and write permissions for the database, but now i cant find the same place i did that - right clicking on the database and properties doesnt bring up the box it used to!

Rob · April 12th, 2005, 03:18 PM

http://www.webforumz.com/viewtopic.p...te+permissions

Dude.... pls try and search before posting.... we've covered this many times...

Indeed, it was your own self who posted that thread... lmao!

benbacardi · April 12th, 2005, 05:29 PM

i know but i followed what was mentioned in that post before, and this time - it DID NOT work

Rob · April 12th, 2005, 06:01 PM

for whaever reason dude, the permissions on the database do not allow the script to update the database.

benbacardi · April 13th, 2005, 12:28 PM

yea but i cant find where to change the permissions - i cant right click on it and find it anymore... sorry rob!

Smokie · April 14th, 2005, 04:06 AM

Ben,

Right click on the folder which the database is in... and on the "security" tab make sure the "write" permissions are set.

benbacardi · April 14th, 2005, 12:32 PM

smokie

thanks but when i right click, and click properties, i only get 2 tabs - general and summary - there is nowhere like there was before to enter read/write permissions. if there was, i would know how to do it because i've done it before! thats why this is so frustrating...

Rob · April 14th, 2005, 03:41 PM

try my post here:-
disable simple file sharing

benbacardi · April 15th, 2005, 12:16 PM

thanks rob